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

3 REPLIES 3
Community Manager

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 

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.

Community Manager

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.