Lookup value

Highlighted
Contributor

Lookup value

Hi,

Would like to ask if I can lookup a list item which is classify as a parent list? I tried it but it does not work. I got values using lookup if the list classify as child list.

 

Thank you.

Darlene

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

Re: Lookup value

@DMManalili , Could you share some screenshot of what you are trying with an explanation?

Highlighted
Contributor

Re: Lookup value

I created a staging module to lookup the value.

first, below is the screenshot of the list.

DMManalili_0-1595757402693.png

second is the system module for the mapping 

DMManalili_1-1595757472305.png

third is the calculation module, I used select function because  I cannot get the values if I used lookup, but I want to use lookup instead.

DMManalili_2-1595757505766.png

 

Highlighted
Master Anaplanner/Community Boss

Re: Lookup value

Hi DM,

 

It appears the DIR COA list is a ragged hierarchical list. In the ragged hierarchy,  lookup works at the child level, not at the parent/summaries. As an alternate for Lookup use Select function.

Why do you not want to use Select function, Is it a production list?

 

~Vignesh M

Highlighted
Contributor

Re: Lookup value

hi VM,

 

Noted for this. I was just thinking if its better to use lookup rather than select but I will use select instead.

 

Thank  you.