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?