Level 2 Sprint 2 DEM03 Growth Rate % line Item

Highlighted
Contributor

Level 2 Sprint 2 DEM03 Growth Rate % line Item

Hey there, Anaplanners!

 

I am on Level 2, Sprint 2 and am having difficulty with the Growth % line item in DEM03.

 

Growth Rate % line item

With this line item, build a formula to pull the Volume Growth Rate % from the DEM02 Volume Growth Rate by Weeks module. 

 

I understand that I need to look up the SKU to get the Parent (Product Family - from SYS08 SKUs details) since that is where the Growth % lives in DEM02, but I am obviously not doing something correctly, because my formula keeps coming back as invalid.

 

Any tips/tricks would be greatly appreciated!

 

Thanks so much!

 

 

2 REPLIES 2
Highlighted
Contributor

Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item

@tlemond You need to look for a module which has product details so that you can map Source module to Target module. And just to add for the lookup to work, you need to look for line item which is source list item formatted.

You can find more details in Anapedia: https://help.anaplan.com/anapedia/Content/Calculation_Functions/Function%20Usage/Formula%20Usage%20T...

Highlighted
Super Contributor

Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item

hi @tlemond 

The SYS08 module should have a line item which gives relation between sku and product family that is list formatted to product family, you can then use that mapping as lookup