Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone please tell me why i am getting strange results in QV when trying to calculate % difference?
I need to find the difference in sales figuers from 2010 to 2011
Here is the expression i am using:
=((Sum({$<YEAR={'2011'}>} NET_USD) - Sum({$<YEAR={'2010'}>} NET_USD)) / (Sum({$<YEAR={'2010'}>} NET_USD))*100)
From my understanding to calculate % difference you need to:
1. Minus the old from the new
2. Divide what is left by the old value
3. Multiply what is left by 100.
The sales figures i have are 2010 = $94 and 2011 = $180. The % difference figure i should get is 91.49% but in QV I get -122% and i can't understand why.
Any ideas???
Thanks,
Sunil
Hi,
it seems to be correct.. have you some selection that interfree?
C u,
Stefano
Hi,
it seems to be correct.. have you some selection that interfree?
C u,
Stefano
Thanks Stefano - after a detailed look into the expressions i was using, you were correct, i wasn't comparing apples with apples!
The above expression IS correct.
Thanks for replying.
Sunil