3014619 - How to check for a NULL in a table and return a 0 within an SAP Analytics Cloud Story using an SAC model based on imported data.

This workflow would be used when a story is based on an SAP Analytics Model using imported (acquired) data.

• 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?

• SAP Analytics Cloud (SAC) 

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