Monthvalue Formula

Highlighted
Occasional Contributor

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

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Monthvalue Formula

@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 

Misbah_0-1601373445479.pngMisbah_1-1601373495523.png

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

Misbah_2-1601373820847.pngMisbah_3-1601373839758.png

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

 

Highlighted
Occasional Contributor

Re: Monthvalue Formula

 

 

Thank you for the clarification.

 

Regards