Sprint 2: DEM02 Module Formula

Highlighted
Occasional Contributor

Sprint 2: DEM02 Module Formula

Hey,

When creating the DEM02 Volume Growth Rates by Week module, the activity wants you to "Write a formula to pull Volume Growth Rates value (in months) from DEM01 module and convert to weekly value". However, under the Anapedia resource it links to explicitly states that the functions listed can aggregate from Weeks to Months but cannot segregate from Months to Weeks. Which is a problem, as it is what we need to do for this activity.

 

Has anyone figured out how to do this?

7 REPLIES 7
Highlighted
Certified Master Anaplanner

Re: Sprint 2: DEM02 Module Formula

In this case, we want to grab the monthly percentages and bring them to the week level. 

 

I would suggest looking into the following formula called MONTHVALUE(): 

 

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/MONTHVALUE.html?_ga=2.190300268....

Highlighted
Occasional Contributor

Re: Sprint 2: DEM02 Module Formula

@jasonblinn,

 

Thank you, I took a second pass and found the solution in the examples

 

For anyone else who was mislead by the wording of the Time Aggregation resource in Anapedia, look at the average example for the MONTHVALUE function.

 

 

Highlighted
Valued Contributor

Re: Sprint 2: DEM02 Module Formula

@Joh04924 

 

You are correct, you can’t “aggregate” /segregate from months to weeks. But you could use a formula that takes the monthly values and distribute it on weeks. 

I believe the training was pointing you to these types of formulas, right?

 

which formula were you considering?

 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Occasional Contributor

Re: Sprint 2: DEM02 Module Formula

This is true, the problem is that I cannot find any functions for segregating time.

any suggestions? 

Highlighted
Super Contributor

Re: Sprint 2: DEM02 Module Formula

Hi @Joh04924,

 

review the Time and Date Functions here: https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_Time_Date_Functions.htm

 

Reading the description and thinking what you want to achieve (push down the value from month to week), you should figure out which function to use!

 

Let me know if you managed?

Highlighted
Valued Contributor

Re: Sprint 2: DEM02 Module Formula

Hi @Joh04924 

 

You will notice here on the board that when we answer training related questions we try to guide the person to arrive at the solution on their own by explaining a concept with which they are having difficulty, rather than give the answer straight out.  This is not only to follow the code of ethics of the training but most importantly -to me- because part of the benefits of the training is to help you learn how to find the information on your own. This is a more valuable skill than learning the functions themselves 😊

 

We are here to help if you have any further questions. Happy Planning 👍

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Super Contributor

Re: Sprint 2: DEM02 Module Formula

Hi @Joh04924 

For taking values from month and copying it to weeks , use the monthvalue() function, it takes the value at month level and puts it to all weeks in the month 

 

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/MONTHVALUE.html

Help on the function