Level 2

Hi,

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)

Tagged:

Answers

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

     

    Nivetha_2-1590478777308.png

     

    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_1-1590478564093.png

     

    Thanks,

    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 

     

    Kanishq17_1-1590516435491.png

     

     

    then your graph will display 2 years data

    Kanishq17_0-1590516401999.png

    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.

     

    Sangya1_0-1590586203152.png