Level 2 - Sprint 2 : Update Historic Volumes

Hello,

I am stuck at step:2.3.9.2 Update Historic Volumes for Baseline Forecast 
I can't deduce the formula for "Offset Volumes for 1st Forecast Year" because I don't know the formula of
"1st Forecast Year?"

Would you please know the formula for "1st Forecast Year?"

Could you help me please
Thank you

Accepted answers

All comments

JaredDolich

@chahiry

You bet. It's not obvious but the intention is that you'll discover the YEARVALUE function in Anapedia.

The 1st Forecast Year will use this function but in conjunction with the Current Period? Boolean line item. Watch out though! Current Period? should be using the ANY Summary. That's how you get the Yearly value because the ANY function will aggregate the Boolean so that if any periods have the Current Period? as TRUE then that Year must also be TRUE. The YEARVALUE function grabs the year value, like magic! Your formula will look like this YEARVALUE(Current Period?)

Hope that helps!

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385