2.3.10 Activity: Create Demand Forecast
Can anyone help what's wrong here?
Not getting the required values.
Like where you're going with this. Let's make a small edit to the baseline forecast. You're being asked to provide LY values for the current year and LY+percentage for the future year. We'll need a conditional.
- If you are in the current year THEN use the "Offset Volumes for 1st Forecast Year" from DAT03
- ELSE take the "Default Forecast" from 52 weeks ago. You'll need to use the LAG function.
Your conditional should exit as quickly as possible. Sometimes we use the NOT function to help with that.
Check your work:
Baseline Forecast = IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year'0
How did you know for Initial Demand Forecast to used the Round, Up, and Exact funtions?
Also, why is the Default Forecast line item is used in the Baseline forecast formula?0