SAP Knowledge Base Article - Public

2892432 - Negative number is processed as positive number in waterfall chart in SAP Analytics Cloud

Symptom

  • Negative number is processed as positive number in waterfall chart on SAC story
  • No problem on Stacked Bar/Column chart 

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Logon SAC.
  2. Open a story with waterfall chart and Stacked Bar/Column chart which are created based on the same model.
  3. Find negative number is processed as positive number in waterfall chart, however no problem in Stacked Bar/Column chart.

Cause

  • In the bar chart, the negative values are negatives, hence they are shown below the axis line.
  • Waterfall is a special chart that shows the positive or negative impact of a measure, taking into account the measure value and its account type.
    • If measure values are expenses (EXP), positive expense (like $50k in salary), is seen as having a negative impact (less money) on the business.
    • A negative expense (like a rent refund), has a good impact (more money), hence the waterfall shows this as an increase with green color.

Resolution

  • The behavior is by design.

See Also

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

Keywords

Negative number, positive, waterfall, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0