SAP Knowledge Base Article - Public

2815107 - No Data displayed in summing formula in a table in SAP Analytics Cloud (SAC)

Symptom

If a summing formula in a table contains a row with no data, then the sum will not display.

e.g.

Column1 Column2 Column3
a 100 200
b 300
c
Sum

Row b is ok since it has data in at least one column, but row c is the problem as it has no data in any column.

Note: By default the rows without data are hidden, you need to right click on the column and select "Show/Hide -> Unbooked" to make them display.

Environment

  • SAP Analytics Cloud 2019.14.1

Reproducing the Issue

  1. Create a table
  2. Click on a column and select the option "Show/Hide -> Unbooked" so 
  3. Ensure the table has at least one row with no data
  4. Create a formula that sums up the rows - making sure to include the row with no data
  5. Note that the formula will not display any data.

Cause

This behavior is by design.  Adding a null value plus a number will always equal null.

Resolution

A workaround to properly add null values is to use the SUM keyword

e.g.

a1+a2+a3 = null (where a2 contains null data)

SUM(a1:a3) = 100 (where a2 contains null data)

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0