Forum Discussion
Solved
Wrong column total for if statement
Hi - I have been reading through the different solutions for showing the expected total in a table for an if statement but haven't been able to apply it to my particular report. Possibly because ...
Hey melaniemdavis
You'll want to use a SUMX formula instead of (or in addition to) an IF to get the total to calculate correctly. Check out the link below:
Your formula would be something like "GreaterThan300Over60Days = SUMX([TotOver60] >300, [TotOver60])"
Hey melaniemdavis
You'll want to use a SUMX formula instead of (or in addition to) an IF to get the total to calculate correctly. Check out the link below:
Your formula would be something like "GreaterThan300Over60Days = SUMX([TotOver60] >300, [TotOver60])"