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
Sirhawk3017's avatar
Sirhawk3017
Icon for Helper II rankHelper II
2 years ago

Did you find an answer to this? Having the same problem.

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

Yeah, I used Sumx(Summarize(......). I then input my table and the columns which were in the matrix. 

 

You need to play around with the order of the summarize.