SAP Knowledge Base Article - Public

3150383 - Null suppression in waterfall chart not working in SAP Analytics Cloud (SAC)

Symptom

Null suppresion in waterfall chart is not working in SAC.

Environment

○ SAP Analytics Cloud (Enterprise) 2021.14.20

Reproducing the Issue

  1. Open a story in SAC.
  2. Add waterfall chart.
  3. Tick Zero suppression option for all used measures and dimensions.
  4. Notice that Zero (+0.0 or (0.0)) values are still displayed.

Cause

It is a behaviour by design to show the null values.

Resolution

  • +0.0 or (0.0) is near-zero but not zero, these values are expected to be displayed and not deleted.
  • Values with no label or bar are not actually zero, they are null.
  • Null suppression is not yet available in charts and it is a longer term feature to be implemented. 

See Also

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

Keywords

Design, waterfall chart, null, zero, suppression, hide , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0