Forum Discussion
Raph
Helper III
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 ret...
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
Gordonlilj
Solution Sage
Solution SageHi,
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