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
-
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 %)
14 -
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
5 -
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.
12 -
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
0 -
I have the same problem thank you @JaredDolich for the explanation
1 -
0
-
@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.0 -
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?
0 -
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
0 -
0
