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...
mwen90Helper III
Helper IIIThanks amitchandak see link to access sample data https://drive.google.com/drive/folders/1o-w5BZBVZCHkfNboDbWg5soJBsnXENTO?usp=sharing
Please note, I just want to recreate Column 3, but only display the positive value of 199.85. I am hoping this will also display as the total.
Thank you so much for the help!
Sirhawk3017
Helper II
Helper IIDid you find an answer to this? Having the same problem.
- mwen90
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.