Forum Discussion
beingEniola
1 year agoRegular Visitor
Measure returning wrong result
Please, I'm working on this data to measure the impact of hosting paralympics on the host countries. But the measure I created to calculate the medals won before and after hosting are not returning c...
HotChilli
1 year agoCommunity Champion
I don't fully understand the description, however, the measure is not going to return the number you want because the variable 'totalmedal' is being passed in first. Once a variable is assigned it doesn't change value.
I think you want to use the SUM(......) in the calculate line instead of the variable.
--
That might get you what you want or not (but it will be better than the existing)