Forecast Moving Average

naufaladin
naufaladin
in Integrations and extensibility
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?

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

Answers

  • Prajjwal88
    Prajjwal88

    Hi @naufaladin ,

    Your formula appears to be working correctly. However, since you're applying it to the Quantity line item, which has a value of 0 for weeks starting from FY25, hence the result is showing as 0 from Week 3 itself.

    Alternatively, I recommend using MOVINGSUM() instead of OFFSET() which would then look like:
    MOVINGSUM(Quantity, -2, -1, AVERAGE)

    I hope this helps.

  • naufaladin
    naufaladin

    @Prajjwal88 this still stuck in week 1

    image.png

  • Prajjwal88
    Prajjwal88

    @naufaladin ,
    Can you show the value in Quantity Line Item for Week 51 FY 24 , Week 52 FY 24 or just show the week values and the more information about the forecast Line Item which you're using from SYS03.

  • SriNitya
    SriNitya
    edited January 21

    @naufaladin

    As per the screenshots there are no values in Quantity line item from Week 1 FY 25.
    So in Forecast line items from Week 2 FY 25 values are "0".
    Hope it helps.

Categories