3603975 - How to change Null values to zero SAC

• How to change Null values to zero SAC

• SAP Analytics Cloud 2025.x.xx

1. Create a story based on data source which has NULL value.
2. Required to change the NULL value to 0 in SAC side instead of data source side.

N/A

1. In Measure part, click More(...).
2. Click Add Calculations....
3. Select Calculated Measure type, also input Nname(ID) and Description.
4. Add Formula IF(ISNULL(["1111TestModel":Measure1] ) ,0 ,["1111TestModel":Measure1] ) and click OK.
5. Then there will be a measure replace all NULL value to 0.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
  • https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add any relevant text, keywords, warning messages or error messages to the text search field to filter the results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

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

empty, change, replace, method , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem