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

    Calculate % Difference

    Sunil Kenth

      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???