2.3.8.4 Create DEM02 Volume Growth Rates by Week module

Hello,

I have followed the instructions in "2.3.8.4 Create DEM02 Volume Growth Rates by Week module "and used the formula WEEKVALUE('DEM01 Volume Growth Rates'.Growth %) but the values are zero after using the formula.

Not sure whether I am right or wrong !

Comments

JaredDolich

@Jitendra10

Oh, so close! You're on the right path though. DEM01 is a monthly module so if you want to refer to a value from DEM01 you'll have to grab the monthly value by using MONTHVALUE.

Growth % = MONTHVALUE('DEM01 Volume Growth Rates'.Growth %)

yashbhadoria

Hi @JaredDolich

I was also stuck on same problem. I tried the formula as told by you. But then, it is showing same percentage for week as for month. Is it correct to show that way?

Screenshot attached

Month_to_week_conversion_115119.jpg

JaredDolich

@yashbhadoria

Awesome callout.

Your solution is correct because we don't have a more granular source to allocate the percentage by week. I suppose you could use LY by week but realistically, that's not too reliable due to holiday shifts, seasonal changes, pandemics, etc.. In real life, the monthly allocation could a combination of LY data and the monthly planned percentage. In this case,

Calculate the dollar or unit increase for the month using the monthly planned percentage
Calculate each week's contribution to the month using LY as a benchmark
Allocate the TY monthly units/dollars for each week based on it's respective weighted contribution
Calculate the resulting increase YoY

This is way more complicated than the certification requires but when you have a real implementation you may have to be more precise.

yashbhadoria

Thanks a lot@JaredDolich

It will definitely help me, in future, for practical scenario. As for now, I will be using the MONTHVALUE formula due to complications. Thanks for the help.

Yash Bhadoria

Celik

I have the same problem thank you @JaredDolich for the explanation

Markcol

I have faced same problem, too.
Thank you so much @JaredDolich.
Mark

MI1110

@JaredDolich
I also landed to WEEKVALUE('DEM01 Volume Growth Rates'.Growth %).
But when I have implemented your suggestion it really worked.

So I am really anxious to know the explanation on this.
Could you please elaborate it.

jameskelly

I'm still confused about this. Wouldn't you need for each month to return whether it's 4 weeks or 5 weeks based on the 4-4-5 timing and then take the growth rate weekly as (growth rate monthly ) ^ ( 4 or 5 depending on month) -1, so that the compounded weekly total per month matches the month?

Or we are saying, the model as a less complicated version should just assume the same monthly rate per week?

RavinderB

Time functions such as weekvalue(),

monthvalue() ... etc act like compound functions and assume the values returned are the same for each point in time eg 1 month of 1% aggregates to 1% for each week in the month.

For training this is not an issue, but in reality a more accurate, weighted function is required. eg weighted time functions.

This is not covered in the training, but a preferred solution.

Ravinder

akrem

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…