Forum Discussion
Solved
my data not summing correctly
Hello, I have a matrix where only one of my "Co Sign Amount's" is not summing in the total. Do you know how I can make it sum? It is currently off $25. Here is the formula that I am using for ...
Ok, try this then:
If Measure = IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value])
Provider Payout 5 = SUMX(Sheet1, [If measure]).
If that doesn't work, then we will need to create the SUMMARIZE expression but including all the columns in the visual.
Ok, try this then:
If Measure = IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value])
Provider Payout 5 = SUMX(Sheet1, [If measure]).
If that doesn't work, then we will need to create the SUMMARIZE expression but including all the columns in the visual.
PaulDBrown Oh my goodness, that worked!!! Thank you so much!!!!