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 !