SAP Knowledge Base Article - Preview

3014619 - How to check for a NULL in a table and return a 0 within an SAP Analytics Cloud Story.

Symptom

  • When a table has columns that contain a NULL value it is needed to check for these values and convert them to a specific value for use in other calculations (Example: Add/Subtract) to ensure that the expected results are generated.
  • How can a column be checked if it is NULL and then ensure that a specific value is used instead if it is NULL?


Read more...

Environment

  • SAP Analytics Cloud (SAC) 

Product

SAP Analytics Cloud 1.0

Keywords

Null Value, Function, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , column , calculation , null , formula , LOD-ANA-TAB , Table , LOD-ANA-PL , Planning , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.