Forum Discussion

StaceyGriffeth's avatar
StaceyGriffeth
Icon for Helper II rankHelper II
5 years ago
Solved

Display hyphen instead of blank

Hello,   I have BI financial statements and would like to have a hyphen display instead of a blank in case of no data or zero value.  Below is an example of the financial statement:   The c...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    You could wrap each of the switch statements with IF ISBLANK([Nautic...YTD]), "-", FORMAT(DIVIDE...)

    that should do it!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Push your switch statement into a variable

 

then 

 

RETURN IF(0+variable==0,"-",variable)

Anonymous's avatar
Anonymous
Not applicable
2 years ago

this works