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)

Accepted answers

All comments

emmaliao

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.

Nivetha

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.

Thanks,

Nivetha K

Kanishq17

@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

Sangya_*23046

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.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…