8 Replies Latest reply: Aug 25, 2016 6:40 AM by Sunny Talwar RSS

    Need to calculate Perc diff this month last month

    kushal thakral

      Hi All

       

      i have a requirement to show data like below

      where i am calculating % diff of current month and same month last year for all the months and also calculating % diff of current three months and same three months last year

      Can any one help me or suggest something

         

      YearMonthABCIncrease on same monthIncrease on same quarter in previous Year
      2016Aug10=(10-40)/40
      2016Jul20
      2016Jun30
      2016May40
      2016Apr50
      2016Mar60
      2016Feb70
      2016Jan80
      2015Dec90
      2015Nov10
      2015Oct20
      2015Sep30
      2015Aug40
      2015Jul50
      2015Jun60
      2015May80
      2015Apr10
      2015Mar30
      2015Feb10
      2015Jan30
      2014Dec50
      2014Nov60
      2014Oct10
      2014Sep50
      2014Aug30
      2014Jul40
      2014Jun30
      2014May50
      2014Apr60
      2014Mar20
      2014Feb30
      2014Jan50

       

      Thanks

      Kushal