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

vasunatari · 2023-04-11T05:46:34+00:00

There was an error rendering this rich post.

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.

Accepted answers

AjayM

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!

All comments

AjayM

Hi @vasunatari ,

Cheers!

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

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

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…