3 months average of historical sales the year before

Options
riyazpasha9
riyazpasha9 Member, ALL USERS, GroupMember Posts: 3 Occasional Contributor
in Planning & Modeling

Hi,

I need to calculate the three months average based on the historical sales data the year before.

For ex: Jan 20 Feb 20 Mar 20 - Average values should go under Jan 21.

100,0,100 - 66.7 Jan 21 value

Please could you suggest the optimal solution for the same? I have attached the screenshots for reference 

riyazpasha9_0-1637867340180.png

riyazpasha9_1-1637867398637.png

 

riyazpasha9_2-1637867469722.png

 

Tagged:

Comments

  • riyazpasha9
    riyazpasha9 Member, ALL USERS, GroupMember Posts: 3 Occasional Contributor

    Hi @ChrisAHeathcote ,

     

    I think the end period instead of -9 should be -10 then values would be right I guess. The test forecast is the line item that has an end period as -9 and the test line item has -10 as end period

    riyazpasha9_0-1638085305391.png

     

    Also if you could help me understand the behaviour of the end period. 

     

    Thank you

     

    Regards,

    Riyaz Pasha

  • riyazpasha9
    riyazpasha9 Member, ALL USERS, GroupMember Posts: 3 Occasional Contributor

    Hi @ChrisAHeathcote  ,

     

    I got the logic. 12-9 = 3 which gives the average for 3 months including the current period(Jan 21 value - Jan 21, Jan20, Feb20,) 

     

    Thank you so much, Chris

     

    Regards,

    Riyaz Pasha

  • LizySH
    LizySH Member, ALL USERS Posts: 2 New Contributor

    this is difficult for me

Categories