SAP Knowledge Base Article - Public

2694053 - Thresholds doesn't show expected result in calculated columns on two versions in SAP Analytics Cloud (SAC)

Symptom

  • Thresholds doesn't show expected result in calculated columns on two versions in SAP Analytics Cloud

Environment

  • SAP Analytics Cloud 2018.15

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a story with Table on one planning model.
  3. Choose two versions (i.e., Actual, Budget) into Columns of the table.
  4. Select the header of the last version(column) and then select Add column/row after member to add a Variance column (=C2-B2)
    => The new column shows the difference between the twos version for each account.
    => You can find an example from help page: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/1c58c140816f408ebcae3705fe12898f.html.
  5. Select the header of the Variance column and then add a New Thresholds for this calculated column.
  6. Enter value into Ranges like:
    - Red:   < 0
    - Green: >=0
  7. All values in the Variance column will shown in Red even the value is not in the defined range.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0