4 Replies Latest reply on Aug 7, 2018 4:47 AM by Simon Runc

    How to calculate Year on Year change with previous year % change

    Benedict Sebastian

      Hi,

       

      I am trying to calculate a 1% increase in our staff numbers to existing staff numbers for period 2012 to 2017.

       

      This is what I am trying to achieve :

       

       

      I am using below formula. But the below formula is not doing what we want. Can any one help out ?

       

      if INDEX()=1

      then

      sum([SIP])

      ELSE

      sum([SIP])+lookup(running_sum(sum([SIP])),-1)*0.01

      END

       

       

      Thanks,

      Ben

       

      Attached packaged workbook.

       

      Mavis Liu

       

      Zhouyi Zhang

       

      Simon Runc