Level 2 Sprint 2 - 2.3.11.3 Create Line Chart Saved View

Hi there,

 

While creating the saved view for the line chart for my DEM03 Demand Forecast module i noticed that I only have 1 year of data for FY20.  The requirement is asking for a view with 2 years of data (FY20 & FY21).   I'm looking for some help in getting my formula correct.

 

What i did was i created a new line item in my DAT03 Historic Volumes to give me the volume for FY21.  Like this:

 

Offset Volumes for 2nd Forecast Year: 

 

IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN OFFSET(Volumes, 52, 0) ELSE 0

 

(I simply removed the negative sign that was in front of the offset parameter for the 1st Year line item.)

 

Then in my DEM03 Demand Forecast module I entered this formula to give me the 2 year view:

 

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 2nd Forecast Year'

 

I did not get an error, but i also did not get values in FY 21.  Here's what my view looks like with the formula in there:

 

no values in fy21.png

 

Can anyone help guide me in the right direction?

 

Many thanks,

 

-Paul 

 

 

Comments

  • Hi @pmorgan ,

     

    For the '1st Forecast Year' Here you can select '2nd Forecast year' as just 'NOT 1st Forecast year' . It will be selected FY21 . 

     

    Then for the historic volumes you can use nested If condition . 

     

    IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE IF  'SYS01 Time Settings By Week'.' Forecast Year?' Then OFFSET(Volumes, -104, 0) ELSE 0 . 

    You can take values OFFSET(Volumes,-52,0) only for the '2nd Forecast Year' as well. 

     

    Correct me if I'm wrong . 

     

    Hope this helps . Let me  know weather this works or not . 

     

    Thank you,

    Puneeth HP 

     

     

    Success is the Intersection of Dreams and Hardwork!

  • @pmorgan 's post here has been very helpful indeed, but it leaves a feeling if you are doing the right thing.  For anyone who wants an assurance that you are going for the right direction, here is the one.  In task 2.4.4.2, on the second bullet point, along with creating the overriding architecture for volume amounts, you are asked to check if you are using the default forecast values from FY20 for FY21.  So, this supports Paul's suggestion.  

    Screenshot 2020-11-27 at 13.21.06.png

  • upload.pngi entered these formulas for line items in demand forecast module but idint get  any values and even error also please check my formulas and tell me what will i doi entered these formulas for line items in demand forecast module but idint get any values and even error also please check my formulas and tell me what will i do

  • Brilliant, worked like a charm.

    Cheers