SAP Knowledge Base Article - Public

2901543 - Report Zero Suppression

Symptom

Zero Suppression is not working for Key Figures in Rows or Columns in your reports

Environment

  •  SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics.
  2. Go to Design reports.
  3. Search for your Report.
  4. Open the report and run it.
  5. Change to "View".
  6. Click the 3 ... for "Key Figure".
  7. Click on the General Tab.
  8. Add Suppression of zeros in either rows or columns.
  9. You notice that the zeros are not suppressed and still showing in the report.

Cause

The "Apply Suppression to Rows" only works, when all Key Figures in the Row are zero; in that case the complete line is hidden.

 If only the "Key Figure ABC" is zero, and "Key Figure DEF" is greater than zero, the setting will have no effect.

The same can be said for trying to suppress values in columns. If one of the figures is greater than zero then it will have no effect.

Resolution

The system is working as designed.

Keywords

Zero, Zero Suppression, blank, report, key figure, settings , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Business ByDesign all versions