Forecast Moving Average

naufaladin
naufaladin
in Academy Discussions
image.png

Hi guys I want ask you, why doesn't the value on FY25 continue? it stops calculating week 1, I want to continue the calculation (for example week2 in FY25 is the sum of week 52 fY24 and week1 FY25 div 2. Is it possible for me to do that?

Answers

  • naufaladin
    naufaladin

    Week 1 FY 25 = (Week 51 FY 24 + Week 52 FY 24)/2
    Week 2 FY 25 = (Week 52 FY 25 + Week 1 FY 25)/2
    Week 3 FY 25 = (Week 1 FY25 + Week 2 FY 25 )/2
    Week 4 FY25 = (Week 2 FY25 + Week 3 FY 25)/2

    etc

Categories