Weighted average, similar to sumproduct in excel

Options
anupgade
anupgade Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi all

I have 4 line items vis. Actual demand, D1, D2,D3, Forecast demand. Having monthly time dimension for FY 20.

Need to calculate Forecast demand for each month based on this calculation

Forecast for April 20 = (Actual demand for Jan 20 * D1+Actual demand for Feb 20 * D2 + Actual demand for Mar 20 * D3)/ sum D1 +D2+D3

Basically its a 3 month moving average, considering weights at the same time.

File is attached for your reference

 

Thanks

Tagged:

Comments

  • anupgade
    anupgade Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Yes, but the question arises how to incorporate those weights in the calculation.

  • anupgade
    anupgade Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Occasional Contributor
    Thank you
    @prabhu

Categories