Contributor

## 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 !

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

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 %)

Jared Dolich
7 REPLIES 7
Moderator

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 %)

Jared Dolich
Occasional Contributor

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

Moderator

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.

Jared Dolich
Occasional Contributor

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.

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

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

Occasional Contributor
@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.