Hey,
How can we use finditem() to search elements of a numbered list (Display Name)??
Hey @PratyakshDua01 maybe this post would help you regarding the FINDITEM() with a numbered listhttps://community.anaplan.com/t5/Anaplan-Platform/FINDITEM-on-Numbered-List-Without-Code/m-p/45252#M5445
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?
Or
Do you want to return the Display Name?
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
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 .
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
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…