on 2024 Oct 09 5:50 PM
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:
Has anyone successfully implemented a solution where numeric 0 values are replaced with blanks? Any help or suggestions would be greatly appreciated!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.