Forum Discussion
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...
Did you find an answer to this? Having the same problem.
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.