Weighted average, similar to sumproduct in excel
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