Categories
Need DV custom format to manage blank values
Unlike Classic Analytics, DV does not have the custom format to manage blank values.
IFNULL function will work only if the underlying value is actually NULL. In this case, for some of the combination of dimension values there is NO measure value at all, which is not the same as NULL.
Source: SR 3-33243228241
Comments
-
In classic analytics, we set Data format for the column by setting
- Custom with Custom Numeric Format as ###0;-###0;0
Customer is looking for similar option in DV1 -
I voted for it. Needs more votes.
1 -
Agree Ben, voted!
1 -
Thank you @Andy Kins !
0 -
Circling back to this request - would be significantly beneficial. Thanks!
1 -
I wonder if the recent feature (Jan 2025) that allows conditional formatting on attributes will accomplish the same thing.
0 -
Hi @Dorothy Joseph-Oracle - is the conditional formatting on attributes in the 25.R1 release? Thanks!
0 -
@Andrew at MKL It is just the "January 2025" release for OAC. See this video describing the functionality:
1
