Forum Discussion

Oscar's avatar
Oscar
Contributor
4 years ago
Solved

Show 0.0 in Cube View Data Cell instead of blank cell

I built a cube view which contains blank cells (this is expected) as there is no data in the intersection. How can I forcibly show 0.0 in these cells (intersections) instead of blank cells? Thanks!
Cube View
  • twn1's avatar
    twn1
    4 years ago

    Hi Oscar, 

    You can create a new U8# Dynamic Calc member with the following code:

    This should replace blank cell with 0 after you layout the CV report with the new UD8 member.

PFowler's avatar
PFowler
New Contributor II
3 years ago

Did you do this without creating a business rule? Would you be able to show screenshots of the formula so I can visualize it?