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

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…

Quick Links

Recent release news

Popular tags