Level 2 Sprint 2 DEM03 Growth Rate % line Item

Tricia

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!

 

 

ashish.banka

@Tricia 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%20Tips.htm

Kanishq17

hi @Tricia 

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