Forum Discussion

New Contributor

3 years ago

Format to show "-" when "0" within cubeviews

Is it possible to have a number formatting to show a dash "-" rather than a zero "0"? Thanks

Contributor II

3 years ago

Thanks for asking the question. I learned something new as well.

This should work --

    If (CellAmount = 0.00) Then
        NumberFormat = "-"

Would appreciate a Kudo.

Cheers,

Mustafa