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

Options
ethanmgomes
ethanmgomes Member, ALL USERS Posts: 2 New Contributor
in Planning & Modeling

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?

 

ethanmgomes_0-1635033694767.pngethanmgomes_1-1635033709698.png

 

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:

ethanmgomes_2-1635033800163.png

ethanmgomes_3-1635033878967.png

 

Any help on this would be great!

 

Thanks,

 

Ethan Gomes

Tagged:

Comments

  • ethanmgomes
    ethanmgomes Member, ALL USERS Posts: 2 New Contributor

    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.

     

    ethanmgomes_1-1635169430138.png

    ethanmgomes_2-1635169503906.png

     

    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

     

     

Categories