why is my formula not returning any values

I have a numbered list in Anaplan (#Job Profile) this list has a Unique Code for each of the members in the list. the list also contains property line items called "Comp Code" and "Comp Location"

I have data module that is being populated with Comp Code values and Comp Location values. What I am trying to achieve is to use these values in the data module to retrieve the Code of the list member.

I started with creating a "Composite Code" for the Comp Code and Comp Location in both the list and in the data module. (Attached blueprint)
Composite Key = 'Comp Code' & "_" & NAME('Comp Location')

I created a line item in the data module where I would retrieve the code of the matching list member of the composite key field:

Formula used: CODE(FINDITEM(#Job Profile, Connect Composite Key))

However I am not seeing any values being populated in the field. To check for syntax error, I exported the #Job Profile List and picked the composite key value from the data module, when I search the list I am able to locate composite key in the list. Any ideas why I am not able to see values populate? Attached blueprint of the list and the data module for reference.

Data Module:

List:

Accepted answers

All comments

BenjaminNiel

Hi @Walker32,

What is the unique code in the numbered list? If it's not similar to "Connect Composite Key", the FindItem will not work.

In the FindItem function, you need to reference a text (here "Connect Composite Key") which is the same as either the list item or the code (and that's usually the preferred option with a numbered list). But, here, it seems that the text that you try to reference ("Connect Composite Key") is similar to a property ("Composite Key").

Hope this already helps!

Walker32

Thanks @BenjaminNiel - The Code of the numbered list is different from the Composite Key in the data module and the list.

My approach was that because the "Connect Composite Key" line item in the data module is the same as the "Composite Key" property in the numbered list, i would be able to use that relationship to find the associated member of the list.

Is there an alternative method of how I would be able to achieve this?

BenjaminNiel

@Walker32, I found an alternative but it requires to create a specific list for the Composite Key.

You have your Job Profile numbered list with the code and the Property "Composite Key"

2. Create a Composite Key list

3. Create a Job Profile SYS Module with the Code, the Composite Key property and the Composite Key from the list

4. Create a Composite Key SYS Module to map with the Job Profile Code

5. In your main module, you can now find the Job Profile code

It works like this, hope that helps!

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