Forum Discussion
Helper IIIIF FUNCTION WITHIN SUMX PROBLEM
Hello,
I have a measure named "Logistic costs" to calculate 0,45 € multiplied by sales quantities if sales quantites are > 0 otherwise it should return 0.
In the result below, the measure returns 0,90 € despite the fact the value for Sale QTY is 1.
Could you please help me to solve this?
Many thanks
Raphaël
Hi,
Are you summarizing any of the columns like the sales column?
If that is the case it would summarize multiple rows into one which would explain why you would get 0.90 instead of 0.45 as the measure would than add up 0.45+0.45 = 0.90
1 Reply
GordonliljSolution Sage
Hi,
Are you summarizing any of the columns like the sales column?
If that is the case it would summarize multiple rows into one which would explain why you would get 0.90 instead of 0.45 as the measure would than add up 0.45+0.45 = 0.90