Level 2 Sprint 2 DEM03 Growth Rate % line Item

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.

Accepted answers

All comments

AashcaJ

@Joh04924 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

Joh04924

Thank you!

Kanishq17

hi @Joh04924

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]

TriciaL

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

Thanks!

neg177

Hi,

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

augustus.perera

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

it brings no value.

augustus.perera

refer weekly % module

augustus.perera

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

the DEM1 Module view

jjayavalli

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

Not sure what am I missing this time.

SRoberts

Looks like everyone 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.

jjayavalli

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:)

mebby2k

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

Evahong

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

P3_132020.png

MKAnaplan

Having issues uploading DEM03 Growth rate. It's showing the % under Growth % instead of products.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…