Monthvalue Formula
Hi
Im revisiting my formulas and find that the output is the same with either A or B : Is there a difference between the two ?
I want to apply the monthly growth values to weeks.
A. MONTHVALUE('Volume Growth Rates'.Growth %)  WEEKVALUE('Volume Growth Rates'.Growth %)
B. MONTHVALUE('Volume Growth Rates'.Growth %)
Thanks for your response.
Cheers
Answers

Let's understand what is happening here
MONTHVALUE('Volume Growth Rates'.Growth %)  WEEKVALUE('Volume Growth Rates'.Growth %): This output is dependent on the timescale of your module as well as the Summary of your line item (Ignore the summary as of now) Let's say if your module timescale is WEEKS
Results are different as you can see it in screenshot that is because we are applying formula it a more granular level of time which is WEEKS
Let's change the Timescale to MONTHS and apply the same formula
Results are same in both these cases reason being there are no WEEKS in the module and hence it will always output 0 to the second part of the formula.
Hope that helps
Misbah
1 
Thank you for the clarification.
Regards
0