9 Replies Latest reply on Jan 16, 2017 7:14 PM by Shinichiro Murakami

    How to calculate 4 week average

    Claire Chen

      Hi all,

       

      Below is the example of my workbook,

       

      I want to show 4 weeks average forecast by model so I cannot use WINDOW_AVG function.

       

      My data looks like this:

       

      For example, the 4 week average forecast value for week 45 will be (wk 44+ wk 43 + wk 42 + wk 41) / 4

       

      I was using datediff function at first but it didn't work...which function should I use to get this value?

       

      Thanks,

      Claire