Forum Discussion

mwen90's avatar
mwen90
Icon for Helper III rankHelper III
4 years ago

If 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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

  • mwen90's avatar
    mwen90
    Icon for Helper III rankHelper III
    4 years ago

    Anonymous  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! 

     

  • mwen90's avatar
    mwen90
    Icon for Helper III rankHelper III
    4 years ago

    Hey Anonymous 

     

    Hope you're well, 

     

    Just following up if you know how to make the formula you suggested total in the matrix? As shown below, i can't get the totals to show for my if statement?

     

    Thanks again for the help!