Hi,
I am not getting the correct results of the below line items, kindly help me to validate the below formulas:
1. Forecast Demand : 'DEM03 Demand Forecast'.Final Forecast
2. Shipping Time Weeks: 'DAT02 Shipping Metrics'.'Shipping Time (Weeks)'[LOOKUP: 'Temp - P2 Product', LOOKUP: Shipping Method]
Thanks!
Solved!去解决方案。
The value ofForecast Demand在INV01 referencesFinal Forecastin DEM03 which in turn depends on Override, So check that out.
The 2048 is the number based on the initial data loaded from the files, but if you make any changes to this period then the Forecast Demand will be different.
In summary, having a different number doesn't mean you have the wrong formula, it is most probably due to changes in input data
1. The value which I am getting is 2025 and what is available in "Page Review the INV01 Line Item Formulas and Summary Method settings" is 2048.
2. Bingo, I was referring the incorrect module - Thanks a lot!
The value ofForecast Demand在INV01 referencesFinal Forecastin DEM03 which in turn depends on Override, So check that out.
The 2048 is the number based on the initial data loaded from the files, but if you make any changes to this period then the Forecast Demand will be different.
In summary, having a different number doesn't mean you have the wrong formula, it is most probably due to changes in input data