1 Reply Latest reply on Mar 9, 2017 5:39 PM by lei.chen.0

    Trouble with Cumulative Moving average

    Patrick R

      Wondering if this is possible. Wanted the moving average of the past 30 days in sales but cumulative. All of the last 30 days cumulative average. Not sure how to make the calculation. Didnt provide the books but its seems like it should be doable. I can get a moving average on a 30 day basis, but i want to try and get a sliding window for the past 30 days.

       

       

      example: 1 2 3 4 5 6 7 8 9 10

      5 day cumulative average would be 1+2+3+4+5 = 15, next day would be 2+3+4+5+6= 20 etc. Not sure on the Calc

        • 1. Re: Trouble with Cumulative Moving average
          lei.chen.0

          Hello Patrick,

           

          I created a simple sample as follows.

           

          You can replace the parameter [Select Date] by something like today() function.

           

           

          Of course, depends on your data and workbook design, it might not be so easy to get the calculation.

          If there's any problem, please share some sample data or a packaged workbook.

           

           

          Regards

           

          Lei