DEMO 03 Demand Forecast. Baseline Forecast formula

Options
Manohar
Manohar Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi,

I am trying below formula for Baseline Forecast, its working for FY20, but for FY21, data is not populating as expected. 

 

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Final Forecast, -52, 0)

 

Below is the Time Ranges selected for line items, kindly need help on the same:

Manohar_0-1601473770552.png

 

Thanks

 

Tagged:

Comments

  • Manohar
    Manohar Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Occasional Contributor

    Thanks Misbah for the reply,

    If i understood correctly, i have applied model calendar and mentioned the formula as below, but still i dont see the values populated in FY21.

     

    Manohar_0-1601477872000.png

     

  • Manohar
    Manohar Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Occasional Contributor

    Thanks Again, in the instruction it says to verify the FY21 values are using the FY20 default Forecast values. Please suggest.

     

    Manohar_0-1601479281470.png

     

  • Manohar
    Manohar Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Occasional Contributor

    We have data in Volumes and 'Offset Volumes for 1st Forecast Year' line items for FY19 and FY20 respectively,

    note: time range is FY19-FY20 for this module

     

    Manohar_0-1601488034048.png

     

  • Manohar
    Manohar Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Occasional Contributor

    Used below formula, now data showing for FY21:

     

    IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN OFFSET(Final Forecast, -52, 0) ELSE 0

     

     

    Manohar_0-1601488882936.png

    PS: I tried earlier the same formula, Some reason, data was not populating in FY21, but now its showing.. 

  • kyaahiyar
    kyaahiyar Member, ALL USERS Posts: 1 Not applicable

    Just check if you have FY20 values in DAT03 module. I am sure you don't have any values in there, that's the reason you are not seeing FY21 in target module.Best Offset Smokers

Categories