Forum Discussion
Solved
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:...
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
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