Forum Discussion
Calculation error with power operator
Hi Gary I've managed to resolve this. I added in a 'divide by total weight' to Measure 1:
Measure 1 = ((Measure A * Weight A) + (Measure B * Weight B)+....+(Measure F * Weight F)) / (Weight A + Weight B+.....+Weight F)
No idea why it was causing problems not having that in.
Anonymous Perhaps put Measure 1 in some table visual and see if there is an odd value in there in some circumstance? I guess another way to put this, in what way are you using the measure, in a table or matrix or in a Card visual?
Hi Gary I've managed to resolve this. I added in a 'divide by total weight' to Measure 1:
Measure 1 = ((Measure A * Weight A) + (Measure B * Weight B)+....+(Measure F * Weight F)) / (Weight A + Weight B+.....+Weight F)
No idea why it was causing problems not having that in.