glob_prop Calculation
Dears
I'm trying to understand the rolling average(glob_prop) calculation so I uploaded only one item/location combination as following
Item_ID | Location_ID | Sales_Date | Actual_Quantity |
1 | 2 | 12/3/2018 | 40 |
1 | 2 | 11/19/2018 | 25 |
1 | 2 | 11/5/2018 | 75 |
1 | 2 | 10/29/2018 | 50 |
1 | 2 | 11/12/2018 | 30 |
1 | 2 | 11/26/2018 | 60 |
1 | 2 | 12/10/2018 | 50 |
- quantity_form = greatest (nvl(pseudo_sale,nvl(actual_quantity, src_actual_quantity))*(1 + nvl(demand_fact,0)),0)
- hist_glob_prop= 26
- Proport_missing = 0
- timeunit = 3 (Weekly)
- IS_FICTIVE =0
- Prediction_Status=1
- DO_AGGRI=1
As per my understanding, the glob_prop Calculation would be
If Proport_missing = 0 then 330/26
If Proport_missing = 1 then 330/7
actually, the calculated glob_prop saved in the MDP_Matrix is 36.6666666666667. and i dont know how it was calculated
thanks in advance