DEMO 03 Baseline Forecast  showing zero's for FY21

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

 

DEMO03 Baseline Forecast module showing zero's for FY21

I have used four more formula's along with the shown in this image. 

Formula 1 : IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' then OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) else IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' then OFFSET(Default Forecast , -52, 0) ELSE 0

Formula 2: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' then OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) else IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' then  LAG(Default Forecast , 52, 0, STRICT) ELSE 0

Formula 3: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' then OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) else IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' then OFFSET(Default Forecast , -52, 0) ELSE 0

Formula 4: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' then OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0)
else IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' then OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) *OFFSET(Growth Rate%, -52,0) ELSE 0

 

My understanding is FY21 values should be Default forecast values  of FY20 but these values are calculated after the first line item  i.e baseline forecast. How can we derive these values? 

Appreciate your help.

 

MaheshKosuri_0-1616085667407.png

 

Tagged:

Comments

  • MaheshKosuri
    MaheshKosuri Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 New Contributor

    @JaredDolich 

     

    Thanks Jared,
    I have used this formula already but no luck. 

    Just for my understanding , all line items will be generated first for each time period here ?  or each line item will be generated for all time periods frist ? How this calculation engine works?

     

    MaheshKosuri_0-1616088915700.png

     

Categories