Level 2 Model Building Month and Year Lookup DEM02

Occasional Contributor

Level 2 Model Building Month and Year Lookup DEM02

Hey All,

 

I'm stuck on the level 2 model building on what appears to be a simple lookup that for some reason is posting back NULL.  It is asking me to take the monthly rate of growth from one model which is in a monthly time scale and apply it to another module which is in weekly time scale.  The ask is that each week should show the monthly rate of growth from the monthly model.  That is, if January is 4% rate of growth in model 1, then every week that is in January in model 2 should show 4% as well.

 

To achieve this, in model 1 and 2 I added 3 line items: Period Start Date "Start()", Month "Month(Period Start Date" & Year "Year(Period Start Date)"

 

The growth %'s were imported into model 1 earlier, so the result in model one is that each product and period shows the growth %, month number and year number.

 

In model 2, I did the following formula: 'DEM01 Volume Growth Rates'.Growth %[LOOKUP: 'DEM01 Volume Growth Rates'.Month, LOOKUP: 'DEM01 Volume Growth Rates'.Year]

 

I want to pull the growth rate for the weekly periods based on the Month and Year in model 1.  This is returning a null value.  What am I doing wrong?  I'm an excel builder so am I just structuring this wrong?

I've attached screenshots of both

5 REPLIES 5
Highlighted
Community Boss

Re: Level 2 Model Building Month and Year Lookup DEM02

jedge@dsi.com 

 

This is a case where there is a different function that works better. Take a look in anapedia around the time and Date functions.

 

https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_Time_Date_Functions.htm

 

Thanks,

Chris 

Highlighted
Occasional Contributor

Re: Level 2 Model Building Month and Year Lookup DEM02

I don't find Anapedia very helpful.  To quote Beetlejuice, it reads like stereo instructions.

Highlighted
Community Boss

Re: Level 2 Model Building Month and Year Lookup DEM02

Anapedia is technical documentation so its not exactly a thriller. However, as you grow your model building skills it will become your best friend. Take a look at which of those functions will bring in that value for that month.
Highlighted

Re: Level 2 Model Building Month and Year Lookup DEM02

Hi jedge@dsi.com,

The answer is from the link https://help.anaplan.com/anapedia/Content/Calculation_Functions/Function%20Usage/Time%20Aggregation....

MONTHVALUE('DEM01 Volume Growth Rates'.Growth %) - WEEKVALUE('DEM01 Volume Growth Rates'.Growth %)

And remember set the Summary to None.

Thanks!
Highlighted
Occasional Contributor

Re: Level 2 Model Building Month and Year Lookup DEM02

Hello thai_van_dang@hotmail.com 

 

For me, the formula MONTHVALUE('DEM01 Volume Growth Rates'.Growth %) also worked as it pulls the monthly data in. 

 

What use is the part  WEEKVALUE('DEM01 Volume Growth Rates'.Growth %)? 

 

Thanks a lot for your help!

 

Felix