cancel
Showing results for 
Search instead for 
Did you mean: 

How to Replace 0 with Blank in SAP Datasphere and SAC

gangareddysomu
Newcomer
0 Kudos
246

Hi Community,

I’m working in SAP Datasphere and trying to implement a solution where the "Subtotal Amt" field shows a blank instead of 0. However, even after applying a calculated column using the following formula:

CASE WHEN "Subtotal Amt" = 0 THEN NULL ELSE "Subtotal Amt"

The system still shows 0 instead of a blank value in Analytic Model and SAC.

I’m looking for a way to display a true blank (or NULL) for 0 values in SAP Datasphere, so that it also reflects correctly in SAP Analytics Cloud (SAC) reports.

What I’ve Tried:

  • Creating calculated columns with NULL.
  • Ensuring data model updates and SAC model refreshes.
  • Attempting conditional formatting in SAC, which did not solve the issue either.

Has anyone successfully implemented a solution where numeric 0 values are replaced with blanks? Any help or suggestions would be greatly appreciated!

 

 

View Entire Topic
umasaral
Active Participant
0 Kudos

To display a true blank instead of 0 in SAP Datasphere, use the formula:

/*sql */
CASE WHEN "Subtotal Amt" = 0 THEN CAST(NULL AS DECIMAL) ELSE "Subtotal Amt" END
/* ******/

Ensure you refresh the data model in Datasphere and the corresponding model in SAP Analytics Cloud (SAC) after making changes.
In SAC, apply conditional formatting to display blank for NULL values.
Validate the implementation with sample data to confirm that 0 values appear as blanks.
This should effectively solve the issue.