2.3.11.3 Create Line Chart Saved View

ankitaga2000

Hi , I am very confused on Level 2 Sprint 2 module.

Here in the above screenshot we are just creating the formula for Growth Rate% , rest everything remains zero.

But then next steps we are asked to create saved views based on Baseline forecast and Initial demand forecast. (Global Assumptions Grid UX)

Am I missing something ?

The Line chart view is also based on this

Please help

Regards,

Ankita

Comments

JaredDolich

@ankitaga2000

Great callout. DEM03 is a really important module. Let's take a look at the baseline forecast:

The correct formula is: 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)

Let's break that down:

First, we need to determine what time period we're currently on. Secondly, If it's the 1st forecast year we should grab the history and "seed" the future with historical data. If it's the second forecast year or beyond, we should just look back 52 periods. This essentially seeds the 2+ years with the same forecast.

The growth rate you've already determined in DEM02. The hint there is to use SYS08 to do the LOOKUP.

Hope that helps. You've got this!

ankitaga2000

I didn’t understand the formula so well. I will try again .

also what about default forecast and initial demand forecast formulas.
I got the formula for growth rate .

JaredDolich

@ankitaga2000

Great question.

Default Forecast = Baseline Forecast * (1 + Growth Rate %)
Initial Demand = ROUND(Default Forecast, 0, UP)

Breakdown:

Default forecast takes the baseline and gives it a percentage increase. The growth rate you already calculated so it's just a matter of continuing the calculation with the line items you already have.
Initial demand uses a new function called ROUND that takes three inputs: The line item you want to round, how many decimals, and the type of rounding, in this case round up.

ankitaga2000

Thanks a lot for helping me out . But one big question which activity it is telling us to create these formulas. Only growth rate formula was told .

JaredDolich

@ankitaga2000

No worries. You'll be building that soon - you've got a head start. You got this!

ankitaga2000

Thank you

NISHI

I am struggling to find out the formulas for

Final Forecast
Forecast CF

Please help me to find out

Thanks

Quick Links

Recent release news

June 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2025 official release notes. The information below offers supplemental information to that post. Security and administration New 'Application Owner' security role Tenant administrations can assign the Application Owner role to users in their tenant.…
Register for our July 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 30, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…