Display hyphen instead of blank

[StaceyGriffeth]

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 columns of numbers are each a measure with a switch statement such that the value for each row is a separate measure.  Here is the measure for the column "AUG 2020":

How can I get hyphens to display in the blanks in the table?

Thanks for your help.

- Stacey

[watkinnc · Accepted solution]

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

that should do it!

[StaceyGriffeth]

Thank you for this suggestion!  I wasn't able to use the "is blank" as in many cases the value was 0, but I was able to do "IF = 0" and get it to return the hyphen.

[watkinnc]

Nice!

[lbendlin]

Push your switch statement into a variable

then 

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

[MKinsight]

this works

[StaceyGriffeth]

My switch statement has some intentional blanks (where I want a blank row between figures), so this approach isn't working.  Thank you for offering the suggestion, though.