Level 2


why my line chart on Dem 03 shows Baseline Forecast and Initial Demand Forecast for one year. I have used the formula for Baseline Forecast:

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



  • The formula is correct. Does your Dem03 module shows two years of data? Trying to understand if it's the chart issue or the data issue.

  • Hi 


    Your formula for the baseline forecast is correct. If you want to show for two years, make sure to set either the past years or future years to 1 as per your requirement in the Time setting(Modal calendar). Since I want the year 2020 and 2021 in my model, I have set the future year to 1.




    In the Blueprint view, set the Time scale to Week.


    Select both the baseline forecast and Initial demand forecast and choose the chart type you want. 




    Nivetha K

  • @Sangya 


    Hi maybe you have not set future years as 1 as model timescale is for fy20 , to set default timescale as 2 years, we must set future years to 1 , it an be done from settings time- future years 





    then your graph will display 2 years data


    hope it clears

  • Hi,

    My time scale is been set to weeks and number of future years is set to 1 too, still my line chart shows the data for one year.