2.3.8.4 - % by week

lcapon
Frequent Contributor

2.3.8.4 - % by week

Hi - how far off am I this being correct?

'DEM01 Volume Growth Rates'.Growth % * 12 / 52

1 ACCEPTED SOLUTION

Accepted Solutions
lcapon
Frequent Contributor

Re: 2.3.8.4 - % by week

I have resolved with this:

lcapon_0-1617182929227.png

 

View solution in original post

8 REPLIES 8
Misbah
Moderator

Re: 2.3.8.4 - % by week

@lcapon 

 

If you are cascading the growth percentages from Month to Weeks, you are way off. You don't have to multiply or divide it by anything - just pull the values from Top to bottom. You will have to use LOOKUP while doing so. 

 

If your Jan month shows 1% growth for a Product Family then the expected result is that all 4 weeks of Jan should show 1% growth rate for that particular product family.

lcapon
Frequent Contributor

Re: 2.3.8.4 - % by week

Thank you - please can you give me a little advance regarding the lookup required - i'm blank this morning!

Misbah
Moderator

Re: 2.3.8.4 - % by week

@lcapon 

 

No Problem. That happens to the best of us.

 

Here is the formula that is required to pull the values. I would recommend you  understand the formula and the usage of LOOKUP in such cases. Since Anaplan doesn't know how to cascade the values from Month to Weeks, we are asking it to use Whatever values we have at Parent level ( Month Level) in Weeks. 

 

Misbah_0-1617177977641.png

 

lcapon
Frequent Contributor

Re: 2.3.8.4 - % by week

Thank you - I'm still lost i'm getting this error.

lcapon_0-1617178423562.png

 

filip.sypniewski
Master Anaplanner/Community Boss

Re: 2.3.8.4 - % by week

@lcapon it might be that your module or line item has different name, did you check that? In general, try to go to the module and click on the line item instead of typing the formula, it can help you to avoid such errors. 

lcapon
Frequent Contributor

Re: 2.3.8.4 - % by week

I did this, but I wasnt sure how to select the second half of the statement?

lcapon
Frequent Contributor

Re: 2.3.8.4 - % by week

Please see screen shots below:

lcapon_0-1617182261938.png

 

lcapon_1-1617182298909.png

 

lcapon
Frequent Contributor

Re: 2.3.8.4 - % by week

I have resolved with this:

lcapon_0-1617182929227.png

 

View solution in original post