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

  • @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

     

  •  

     

    Thank you for the clarification.

     

    Regards