nulls and zeros in the same column?

[#1]

I have a Straight Table chart, where I am trying to get zero values display as '0' and rows where there is no value either blank or '-'.

My formula is as follows:

=IF([launched in last 6 months]='Yes',0,SUM({1<WeeksAgo={'1'}>}[Total Volume (M)]))

But even if there is no data for the row, it's still displaying as '0'.

How do I get the '-' to appear, or for the cell to be blank when there's no data?

[Gysbert_Wassenaar · Accepted solution]

Change the number format for the expression on the Number tab to #.##0;-#.##0;-

[robert_mika]

Maybe nested IF will help

Something like:

=IF([launched in last 6 months]='','-',IF([launched in last 6 months]='Yes',0,SUM({1<WeeksAgo={'1'}>}[Total Volume (M)])))

[#4]

Top man Gysbert!!