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"
Dear community members Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for
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.