Forum Discussion
mwen90
Helper III
Helper IIIIf statement not totalling in matrix
Hi, I have a scenario where I am trying to calculate Column A - Column B. However, some of my Column A items are 0, so the solution is negative Column B value. Where this happens, I want to...
mwen90
Since you have many columns in the table, the columns in the table will sum up automatically based on the fields you included in the table. 199.85 is also a sum value of the rows with "Core", "LG", "IPU". For such many columns, it is suggested to create a measure instead of a column. Because measure is perfectly calculated based on the included filters and fields on the report.
Measure 2 = IF(SUM(Reinforcement[Column 3])<0,BLANK(),SUM(Reinforcement[Column 3]))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
mwen90Helper III
Helper IIIAnonymous it worked, but there's no total at the bottom of the tbale? Do you know how to get it to total? Thanks so much for the help!