Forum Discussion

Oscar's avatar
Oscar
Contributor
3 years ago

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!
  • twn1's avatar
    3 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.