Forum Discussion
suppress zero value in matrix
Hi Guys
I have created this report but do not want the zeroes to show as it affects the appearance.
How can I show blanks instead of zeroes without affecting the totalling.
This is my table:
Line Description Units Sales Profit
Toyota 22 600,000 60,000
Honda 0 0 1,000
Mazda 0 10,000 0
Total 22 610,000 61,000
I hope you can help me
Best Regards
Rollo
You could change your current measures (or create an explicit mesure if you don't have one yet) that does something like this:
Total Units = if(sum([Units])= 0 , blank(), sum([units]))
Then you get this result.
Hope this is what you mean.
Edgar
Thanks for your prompt reply and it worked a treat.
Cheers
Rollo
2 Replies
You could change your current measures (or create an explicit mesure if you don't have one yet) that does something like this:
Total Units = if(sum([Units])= 0 , blank(), sum([units]))
Then you get this result.
Hope this is what you mean.
Edgar
Thanks for your prompt reply and it worked a treat.
Cheers
Rollo