DEMO 03 Demand Forecast. Baseline Forecast formula

Highlighted
New Contributor

DEMO 03 Demand Forecast. Baseline Forecast formula

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

 

7 REPLIES 7
Highlighted
Master Anaplanner/Community Boss

Re: DEMO 03 Demand Forecast. Baseline Forecast formula

@Manohar 

 

Two things:

 

1. Remove the Time range and apply the normal timescale to the entire module.

2. Formula should be just " DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year'" as you would have used OFFSET and IF ELSE statement in the DAT03 Historic Volumes module. You don't need to write it again in DEM03 module.

 

Misbah

Highlighted
New Contributor

Re: DEMO 03 Demand Forecast. Baseline Forecast formula

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

 

Highlighted
Master Anaplanner/Community Boss

Re: DEMO 03 Demand Forecast. Baseline Forecast formula

@Manohar 

 

There wont be any values as you are trying to pull FY19 Values into FY20 as baseline. When you have FY20 historic values you will see FY21 values in this module. But to me you are good to go & don't need to see FY21 values.

 

Good Luck!

Highlighted
New Contributor

Re: DEMO 03 Demand Forecast. Baseline Forecast formula

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

 

Highlighted
Master Anaplanner/Community Boss

Re: DEMO 03 Demand Forecast. Baseline Forecast formula

@Manohar 

 

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.

Highlighted
New Contributor

Re: DEMO 03 Demand Forecast. Baseline Forecast formula

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

 

Highlighted
New Contributor

Re: DEMO 03 Demand Forecast. Baseline Forecast formula

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..