topic Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item in Anaplan Platform https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/92460#M20781

 dem02.lineitem[lookup:SYS08.Prod family] it gives an error message, formula invalid.

Not sure what am I missing this time.

 

 Wed, 02 Dec 2020 03:44:58 GMT jjayavalli 2020-12-02T03:44:58Z Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/75579#M15660

 

For this line item, it is needed to align the dimensionality of the Source Module to Target Module, so that the Target Module can reference the Growth Rate % of the Source Module. See below for mapping reference:

Screen Shot 2020-06-30 at 4.41.32 PM.png

The issue I am having is that I am unable to properly map the formula. Resulting in various error messages.

I have been using variation of LOOKUP, and LOOKUP & SELECT functions, to no avail.

 Tue, 30 Jun 2020 21:48:40 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/75579#M15660 Joh04924 2020-06-30T21:48:40Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/75583#M15664

 I would say you are on the right path with "LOOKUP". Look at the mapping reference again, follow that exact sequence and check your logic.

 

DEM02 --> SYS08 --->DEM03

 Tue, 30 Jun 2020 21:58:15 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/75583#M15664 AashcaJ 2020-06-30T21:58:15Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/75585#M15665

Thank you! 

 Tue, 30 Jun 2020 22:14:30 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/75585#M15665 Joh04924 2020-06-30T22:14:30Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/75649#M15692

hi 

You need to check the dimensions at source and target when using LOOKUP, so you see in source there is P1 and in target there is P3, so need a mapping between P3 and P1, so in the SYS module we get the P1 prod family for P3 SKU using PArent(parent()) , now based on the mapping, you can lookup values from dem02, so it will be dem02.lineitem[lookup:SYS08.Prod family]

 

 Wed, 01 Jul 2020 12:11:42 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/75649#M15692 Kanishq17 2020-07-01T12:11:42Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/81006#M17564

  - were you able to resolve this? I am having the same issue.

 

Thanks!

 Thu, 20 Aug 2020 17:23:55 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/81006#M17564 Tricia 2020-08-20T17:23:55Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/83979#M18315

Hi,

 

Were you ever able to figure out the Formula for the growth rate line item in Moduel DEM03?

 Mon, 14 Sep 2020 21:20:25 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/83979#M18315 neg177 2020 - 09 - 14 - t21:20:25z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/85243#M18794

Hi

 

Please, need some help , I am passing the same passage.

 

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DEM01 Volume Growth Rates'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family] ELSE 0

 

Context: Growth Rate Module P1 , DEM 3 Module has P3 and both P1,P3 are in SYS08

Augustus_0-1601110308965.pngAugustus_1-1601110345104.png

Augustus_2-1601110476361.png

it brings no value.

Augustus_3-1601110591693.pngAugustus_4-1601110602183.png

 

 

 Sat, 26 Sep 2020 08:57:07 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/85243#M18794 augustus.perera 2020-09-26T08:57:07Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/85245#M18795

Augustus_0-1601110760812.png refer weekly % module

 Sat, 26 Sep 2020 08:59:48 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/85245#M18795 augustus.perera 2020-09-26T08:59:48Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/85249#M18796

Hi appreciate some guidance ..both formulas don't bring any values

 

Augustus_0-1601111384804.png

Augustus_1-1601111538807.png

the DEM1 Module view

Augustus_2-1601111600672.png

 

 

 Sat, 26 Sep 2020 09:13:27 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/85249#M18796 augustus.perera 2020-09-26T09:13:27Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/92460#M20781

 dem02.lineitem[lookup:SYS08.Prod family] it gives an error message, formula invalid.

Not sure what am I missing this time.

 

 Wed, 02 Dec 2020 03:44:58 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/92460#M20781 jjayavalli 2020-12-02T03:44:58Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/93631#M21116 < P >的样子yone has figured the correct SYS08 Product Family Lookup for this line, but recall that in a prior step we created DEM02 Volume Growth Rates by Week using formula 'MONTHVALUE('DEM01 Volume Growth Rates'.Growth %)' to bring the monthly value in DEM01 down to a weekly level.

 

My formula was successful when I accessed that weekly growth rate data.

 Wed, 16 Dec 2020 21:49:09 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/93631#M21116 SRoberts 2020-12-16T21:49:09Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/93996#M21227

Hi, so are you suggesting to divide the MONTHVALUE/ 4 to get the weekly Growth %? I have used the Lookup Function here instead.

so wondering. Thank you:) 

 Tue, 22 Dec 2020 16:47:34 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/93996#M21227 jjayavalli 2020-12-22T16:47:34Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/130801#M33428

'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]

 Wed, 26 Jan 2022 16:36:24 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/130801#M33428 mebby2k 2022-01-26T16:36:24Z Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/132020#M33956

I have this problem too. Anaplan shows level mismatch on common dimension (attached screenshot). Are we missing on another dimension?

 Thu, 10 Feb 2022 17:51:08 GMT https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-2-DEM03-Growth-Rate-line-Item/m-p/132020#M33956 Evahong 2022-02-10T17:51:08Z