SAP Knowledge Base Article - Public

2674241 - Calculation with null / blank / unbooked / 'Show empty cells' is not calculating correctly or has an INVALID_VALUE! error in SAP Analytics Cloud

Symptom

An in-cell calculation defined within a table / grid with null / blank / unbooked / 'Show empty cells' values is not calculating correctly or has an INVALID_VALUE! error in SAP Analytics Cloud (SAC).

Environment

  • SAP Analytics Cloud

Resolution

Not able to interpret null values.

Use an IF or SUM range to convert null values (unbooked / empty) to 0 (zero):

  • =(if(B4=null,0,B4)+if(C4=null,0,C4)+if(D4=null,0,D4))/3
  • =SUM(B4:D4)/3

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

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-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0