Level 2 Sprint 2 - 2.3.8.4 Create DEM02 Volume Growth Rates by Week module

vasunatari
vasunatari
in Academy Discussions

Hi Experts -

I am trying to understnad the way to Get the Weekly value for the "DEM02 Volume Growth Rates by Week module ", from what I understand, based on the Montly Growth % in the DEM01 DEM02 has to sholw the weekly Growth %. And I intially tried to use the WEEKVALUE formula but that did not work and when looking at the community posts I see that using Month value formula is correct, but I do not understand why. Can someone explain? TIA.

DEM02 Question.jpg

Tagged:

Best Answer

  • AjayM
    AjayM
    Answer ✓

    Hi @vasunatari ,

    As you can understand from the functions' definition, MONTHVALUE works on a lineitem that is dimensioned by more granular time (WEEK or DAY) to give us source value which is at monthly level, and WEEKVALUE function works on a lineitem dimensioned by DAY level to give us source value which is at weekly level . These functions are used to retrieve source value which is at respective higher level dimension (as per the name of the function).


    Cheers!

Answers

  • vasunatari
    vasunatari

    @AjayM Thanks for your response.

    In the screen shot I shared I am using the MONTHVALUE function to populate the Week 1 FY20 value, when compared with the DEM01 Volume Growth Rates (which is at month) wont the weekly growth rate be less? and Aggregate to the Montly growth rate?

    TIA

    Vasu.

  • Noura99
    Noura99

    @vasunatari did u understand it finally ? I have the same confusion!

Categories