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

Options
Candy
Candy Member, ALL USERS, GroupMember, Community Member Posts: 5 Contributor
in Anaplan Community

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.

 

Candy_0-1617510584213.png

Candy_2-1617510652247.png

 

Candy_3-1617510702283.png

 

Thank you!

Candy

 

 

 

 

 

 

Tagged:

Comments

  • evacarusu
    evacarusu Member, ALL USERS Posts: 5 Contributor

    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

  • Candy
    Candy Member, ALL USERS, GroupMember, Community Member Posts: 5 Contributor

    Thank you everyone for your help! 😊

     

Categories