Which FY (year) is this baseline forecast for? It's for FY20 Correct? The offset formula which you wrote correctly, basically translates to "The value now equals the value at the same time last year". Since your first year with value is FY19 then the formula won't have values for any years FY19 +1 Check the values for FY20, that's your base year..
Keep it up👍
Einas "Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Re: Baseline Forecast in DEM03 Demand Forecast Module is 0 - Level 2 Model Building
That makes sense. I'm glad I have that part correct.
My main issue is in DEM03 Demand Forecast, I cant figure out how to bring the baseline forecast values for FY19 (Historic Volumes) to my current module.
The way I understand it, my formula is checking if the current week/year (Week 1 FY20) is a forecast year, and if that is true, then pull the offset volumes from my historic volumes module. However, I only see zeroes in my baseline forecast line item, where I should be seeing the past volumes from FY19.