2 Replies Latest reply: Oct 4, 2011 6:50 PM by Sunil Kenth

# Calculate % Difference

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

• ###### Calculate % Difference

Hi,

it seems to be correct.. have you some selection that interfree?

C u,

Stefano

• ###### Calculate % Difference

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.