L2 Sprint 2 - 2.3.8.4 Formula to the Growth % Line Item

Candy

Hello,

I struggle with building formulas and would greatly appreciate any help.

I am stuck with last part of the activity where I have to convert DEM01 Volume Growth Rate % (monthly) value to weeks.

Being a new learner, I am not sure if the formula is correct because I am getting zero percentage across the periods.

If anyone can explain what I am doing wrong, that would be great help.

Thank you!

Candy

Comments

evacarusu

Hi @Candy ,

For this exercise you need to bring your growth rate from DEM01 Module which is at month level to DEM02 Module which is at week level. You need a formula to push the value from month level from the source module (DEM01) to corresponding week levels in your target module (DEM02). The formula you have used - WEEKVALUE is pushing from week to days, so you need a different function. Please have a look at the MONTHVALUE function in Anapedia https://help.anaplan.com/8b54b167-4cfc-488c-9f7f-32baac1e1fe7-MONTHVALUE

Thanks,

Elisabet

ChrisAHeathcote

@Candy

Your source module is dimensioned by months and your target by weeks. Therefore, you need to assign a value to each week based on the MONTHVALUE of the corresponding month.

As @evacarusu has mentioned use the MONTHVALUE function to assign the month value corresponding to the week dimension in the target module.

Good luck,

Candy

Thank you everyone for your help! 😊

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…