Finditem() with Numbered List

Highlighted

Finditem() with Numbered List

Hey,

How can we use finditem() to search elements of a numbered list (Display Name)??

6 REPLIES 6
Highlighted
Valued Contributor

Re: Finditem() with Numbered List

Hi pratyaksh.dua@polestarllp.com 

 

Are you saying you have the "Display Name" and you want to return the List Item corresponding to that List Name from the Numbered List?

Or

Do you want to return the Display Name?

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted

Re: Finditem() with Numbered List

I just want to return Display Name of a numbered List from the another Text formatted Line Item using finditem(),Is it possible ??

Thanks for your reply @einas.ibrahim 

Highlighted
Valued Contributor

Re: Finditem() with Numbered List

Hey pratyaksh.dua@polestarllp.com 

maybe this post would help you regarding the FINDITEM() with a numbered list
https://community.anaplan.com/t5/Anaplan-Platform/FINDITEM-on-Numbered-List-Without-Code/m-p/45252#M...

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Master Anaplanner/Community Boss

Re: Finditem() with Numbered List

Hi Pratyaksh,

Complete the FINDITEM normally. Then to get the Display Name, use this formula:
NumberedList.Display Name[LOOKUP: <FINDITEM line item>]

What do you mean by search elements?

Regards,
Anirudh



Highlighted

Re: Finditem() with Numbered List

I have one Text formatted line item in a module and wants to get the display name corresponding to that text formatted line Item members but the problem is finditem() is not able to recognize the text formatted Line Items members from the Display Name so its not returning anything but formula is running .

Thanks for yr reply @anirudh .

Highlighted
Master Anaplanner/Community Boss

Re: Finditem() with Numbered List

Got it now!

In that case the link posted by @einas.ibrahim should do the trick

https://community.anaplan.com/t5/Anaplan-Platform/FINDITEM-on-Numbered-List-Without-Code/m-p/45252#M...

 

But I would recommend adding a code to your numbered list, this can be the same as display name but try to avoid that, because display names may contain duplicates. If you are able to create the code, same as the display name or even any other code, my approach will work fine. Make sure to complete the finditem with the second argument in the formula pointing to the code of the list instead of the display name of the list

 

Hope this helps

 

Regards,

Anirudh