DEM03 Demand Forecast Module

DEM03 Error.PNG DEMO03 -1.PNG

Hello.Can somebody please me with this error. In DEM03 Demand module i am unable to get a data for Year 21,till year 20 all looks good to me,but from week1 FY 21 Baseline,default Forecast,Intial Demand Forecast all values are 0.I i have attached the blueprint too so i can get a better picture where i am doing something wrong.

Comments

jagadishdash

@Sanai

The formula should be :-

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)

So then in 21 it will offset the default forecast value from 20.(you can refer the learning screenshot mark as they given it's clearly mentioned)

Hope it helps for you. If it is please accept my answer as solution.

Thanks,

anand.shekhawat

@jagadishdash

Anaplan has crafted the certifications for learning purpose and allow the 'Taker' to struggle/think and find the solution himself.

We should be helping them to find a way to Solution but not be giving them everything 'Ready to Eat'.

'Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime'

~Anand

jagadishdash

@anand.shekhawat

No doubt, You are right. Already he tried something and missed it. So i explained the learning requirement what they told and so as per that you need to add the formula with the offset hint as well as they given.

So, as they are learning and did something and missed out something i just explained the things what need to add and achieve the final output. so that they can understand the requirement and goahed with that thinking for upcoming learning.

Appreciate for your mentioning the things so they can also get these things.

Thanks,

Sanai

Thanks, it worked.

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…