220.127.116.11 Create DEM02 Volume Growth Rates by Week module
I have followed the instructions in "18.104.22.168 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 !
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 %)13
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?
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.11
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.
I have the same problem thank you @JaredDolich for the explanation1
I have faced same problem, too.
Thank you so much @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.