Baseline Forecast in DEM03 Demand Forecast Module is 0 - Level 2 Model Building

I feel like my formula is correct but for some reason I am only seeing zeroes as values in the DEM03 Demand Forecast module. Is this an issue with the DATA03 Historic Volumes module?

To my understanding, the values in Baseline Forecast should be the volume values from FY 19. Does anybody know where I am going wrong?

Here is what my DAT03 Historic Volumes module looks like:

Any help on this would be great!

Thanks,

Ethan Gomes

Accepted answers

All comments

einas.ibrahim

Hello @ethanmgomes

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👍

ethanmgomes

Hi Einas,

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.

I'm not sure what I'm missing.

Ethan

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…