SAP Knowledge Base Article - Public

2582315 - Waterfall chart displays bars as negative when the values are positive in SAP Analytics Cloud

Symptom

  • Selecting waterfall charts displays as negative values some of the values that should be positive.
  • If you change the chart type to Bar/Column, it displays correctly the positive numbers above the axis and negative below the axis.
  • Account type of [EXP] is being used in the model.

Environment

  • SAP Analytics Cloud 2017.24.4

Reproducing the Issue

  1. Create a chart and select waterfall.
  2. Mix measures from a planning model and add calculations to have positive and negative values.

Cause

  • Using [EXP] as the Account type causes that values have been flipped to display them as negative values in the stories.

Resolution

  • This is a bydesign behavior.
  • When creating calculated measures (Calc = Account) for the [EXP] members the waterfall chart appears properly with positive values.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0