2.3.10 Activity: Create Demand Forecast

omarismailcch1

Hello All, I tried to understand the function from the community question but I do not get it

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'

For this part of function - LAG(Default Forecast, 52, 0, STRICT) - How is it dependent on Default Forecast line item which is dependent on baseline forecast and I visited the LAG function and I understand what it does but with this I am confused.

fenilmpatel

Hi @omarismailcch1,

For the first year, the values are taken from 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' as it is given. For the following years, I believe according to user story given, the baseline values are taken from the previous year using a lag function. This means it picks values from 52 weeks ago. For example, if the current week is week 1 of 2020, it will use the values from week 1 of 2019 as the baseline forecast. I hope Im able to help you.