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.