SAP Knowledge Base Article - Public

2796375 - Blank Cells in Reports


You have a report with multiple rows and columns of data and some of the cells are blank/empty.


  • SAP Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics and select the view Design Reports.
  2. Open and run one of your reports.
  3. You notice that some cells are blank/empty.


This will happen in reports where multiple restricted key figures have been created and no records are available to match one of the restricted key figures.

The reason for this is the blank cells are showing as null as there are no records which match the restriction passed.
No data cannot be construed as 0 and can only be seen as NULL and shown as a blank value.


These blank cells in your report are expected system behavior when using reports with restricted key figures.


Blank, empty, cells, blank cells, empty cells, report, restricted key figures, key figure, restricted key figure, blank fields, fields , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem


SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions