SAP Knowledge Base Article - Public

3047751 - Formula in cell is not working correctly in SAP Analytics Cloud (SAC) when NULL value is exist

Symptom

Formula in cell is not working correctly in SAP Analytics Cloud (SAC) when NULL value is exist

Environment

  • SAP Analytics Cloud (Enterprise) 2021.8.0

Reproducing the Issue

  1. Create a new story on sample model.
  2. Insert a table and confirm there is NULL value in the cell.
    For example: A1 = 10, 7
    A2 = NULL, 4
  3. Insert a new row, make formula equals to "A1 + A2"
  4. Result is showing NULL, 11

10 + NULL = NULL should not be considered as a correct result.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0