5 Replies Latest reply: Apr 27, 2018 2:15 AM by An Pham RSS

    YTD Average per month using Avg/Aggr

    An Pham

      Dear All, stalwar1

       

      i want to calculate AVG from first month of Year to selected month like formula

      Avg_YTD= (avg for each month/number of month)

       

      example:

       

      MonthValues
      Jan-20182
      Jan-20184
      Feb-20185
      Feb-20184
      Mar-20183
      Apr-20183
      Apr-20182

       

      if i selected Mar-2018,it will be calculate from Jan-2018 to Mar-2018  (3 months)

      Expected result is

      Avg_YTD = (avg(2+4) + avg(5+4) + avg(3)) /3 = 3.5

       

      but i am not sure how to calculate the % change correctly. Any help would be appreciated.

      Thanks in advanced

      An Pham