Reference another list in a module dimensioned with one list

My module is dimensioned with a numbered list, let's say Segment>Product#; I'm trying to retrieve the hierarchical parent from another list P2 Product in order to get the product family for each single product.

The line item (format 'List') formula I used was to reference directly that list: PARENT(ITEM('P2 Product')). However, it was incorrect, error notification saying that my line item does not apply to P2 Product list, and it applies to Segment>Product#...

Can anyone help on this issue? Since I've already got P2 Product and Product code as line items in the module, both formatted 'text', I also tried another way by directly lookup the product's family in list: 'P2 Product'.Parent [LOOKUP: Product Code], it's invalid as expected..

I'm not able to get a list formatted P2 Product due to dimension mismatch.

Accepted answers

anikdas

Hi @SaraBTIT

You will need a property against the numbered list. You have not mentioned whether the items in the numbered list corresponds to the same P2 Product level or not.

If you already have the Product Code against the list items, you can apply a finditem to find the item in the P2 Product list.

Finditem link: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/FINDITEM.html

Once you have found the P2 Product List, then apply the parent formula on it.

All comments

anikdas

Hi @SaraBTIT

You will need a property against the numbered list. You have not mentioned whether the items in the numbered list corresponds to the same P2 Product level or not.

If you already have the Product Code against the list items, you can apply a finditem to find the item in the P2 Product list.

Finditem link: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/FINDITEM.html

Once you have found the P2 Product List, then apply the parent formula on it.

SaraBTIT

Thanks a lot @anikdas ! problem solved.

Kanishq17

hi @SaraBTIT ,

you mentioned that you have P2 product code as text, so using finditem, you can find p2 product for that and then use parent to find P1 parent

Quick Links

Can you help?

Unanswered questions

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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385