18.104.22.168 Create DEM02 Volume Growth Rates by Week module
I have followed the instructions in "22.214.171.124 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.
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.