Need DV custom format to manage blank values

Olivia Robles

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

RajeshPolavarapu-Oracle

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 DV

Benjamin Arnulf-Oracle

I voted for it. Needs more votes.

Andy Kins

Agree Ben, voted!

Benjamin Arnulf-Oracle

Thank you @Andy Kins !

Andrew at MKL

Circling back to this request - would be significantly beneficial. Thanks!

Dorothy Joseph-Oracle

I wonder if the recent feature (Jan 2025) that allows conditional formatting on attributes will accomplish the same thing.

Andrew at MKL

Hi @Dorothy Joseph-Oracle - is the conditional formatting on attributes in the 25.R1 release? Thanks!

Dorothy Joseph-Oracle

@Andrew at MKL It is just the "January 2025" release for OAC. See this video describing the functionality:

https://youtu.be/01DPvxkQxfU?si=Bom-S-Qv3-wZBgch