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

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).

• SAP Analytics Cloud

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

• How to find User Assistance for SAP Analytics Cloud?
• Ask a question on the SAP Community!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)

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.

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 (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem