nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Finditem() with Numbered List

PratyakshDua01

Hey,

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

Accepted answers

einas.ibrahim

Hey @PratyakshDua01

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#M5445

All comments

einas.ibrahim

Hi @PratyakshDua01

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?

Do you want to return the Display Name?

einas.ibrahim

anirudh

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

PratyakshDua01

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

PratyakshDua01

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 .

anirudh

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#M5445

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

Quick Links

Can you help?

Unanswered questions

Near-Real-Time Anaplan → Claude MCP: Any Faster Than Bulk Export + MySQL?
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
Anaplan Analyst performance on large, sparse models
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…