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 Hmm, I can seem to replicate this but perhaps try:
Measure 2 = 1 - POWER( 1-[Measure 1], 0.5)I was trying very small numbers like 0.00000001^(.5) and very large numbers, negative numbers, etc.
Still not working I'm afraid Greg
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.