Monthvalue Formula

rmat066sysf

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

Misbah

@rmat066sysf 

 

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