Level 2

Highlighted
Occasional Contributor

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)

4 REPLIES 4
Highlighted
Occasional Contributor

Re: Level 2

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.

Highlighted
Contributor

Re: Level 2

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

Highlighted
Occasional Contributor

Re: Level 2

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

 

Highlighted
Super Contributor

Re: Level 2

@Sangya1 

 

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