2.3.10 Activity: Create Demand Forecast

Can anyone help what's wrong here?

Not getting the required values. D forecast.png

Comments

Like where you're going with this. Let's make a small edit to the baseline forecast. You're being asked to provide LY values for the current year and LY+percentage for the future year. We'll need a conditional.

If you are in the current year THEN use the "Offset Volumes for 1st Forecast Year" from DAT03
ELSE take the "Default Forecast" from 52 weeks ago. You'll need to use the LAG function.

Your conditional should exit as quickly as possible. Sometimes we use the NOT function to help with that.

Check your work:

Baseline Forecast = 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'

mkidd20

@Csta @JaredDolich

How did you know for Initial Demand Forecast to used the Round, Up, and Exact funtions?

Also, why is the Default Forecast line item is used in the Baseline forecast formula?

bogirere

2.3.10 Activity: Create Demand Forecast

Can anyone help what's wrong here?

I am trying this formula but not working

Baseline Forecast.png

tincythomas

Hi Jreddy,

Could you please double check the name of the line item in DAT03 Historic Volumes? or please share a screenshot of that module. Please refer the attached screenshot of module.(chances of spelling mistakes in the line item name)

Thanks and hope this will help you to resolve your issue.

Tincy

OPS

Hi there I added the above formulas for Growth Rate % however I get the following error message:

Not sure if I have something wrong in my SYS08 SKU Details Module? please help. Thank you

Deepak5805

Hi OPS,

So this came because your SYS08 SKU Details Module does not match the dimension of the values of the item you are trying to map.

Then you have to check your dimensions of the following modules:

Here I am attaching the dimensions and formula which i had used:

SYS08 SKU Details : P3 Sku
DEM02 Volume Growth Rates by Week : P1 Product Family

Hope this will help you to resolve your issue.

Thanks

Deepak

jagadishdash

rchaudhry

@JaredDolich

I used the formula but its showing as….

Lag function can not be used for summary time period.

can you help?

Quick Links

Recent release news

August 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our August 2025 official release notes. The information below offers supplemental information to that post. Planning experience Multi-browser tab syncing When changing context or data on a UX page, you can now view real-time data updates across up to five…
July 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our July 2025 official release notes. The information below offers supplemental information to that post. Planning experience External URL navigation button Page builders can configure navigation action buttons to link to external URLs, including non-Anaplan…