2.4.2.2 Check your work

I used 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' formula in Baseline Forecast But in 2.4.2.2 work check FY21 is also filled.How can I fill FY21 in my module

DEM03_screenshot_1_143945.jpeg

DEM03_screenshot_2_143945.jpeg

Comments

JaredDolich

@RAJAT786

You're super close and on the right track. The correct formula will look like this:

Spoiler

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

Let's break that down a bit.

Since we're using a conditional "IF" then we want the most likely outcome to be first so Anaplan will exit the formula sooner. Helps with calculation optimization. In this case we'll use the NOT function.
If it's not the first year then it must be a future year so we need the forecast. We'll use the default forecast from 52 weeks ago and move it forward.
If it's the first year then we need the historical / actual values. In that case we'll go to DAT03 to get that information.

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…

Quick Links

Recent release news

Popular tags