As a modelbuilder I would like to use FindItem with a property or line item
I have seen that I am not the only one facing the issue that there is property or lineitem which is neither a code or name of list but it is needed for identification, like a WHERE statement in SQL.
Might it be possible to extend the FINDITEM function by an optional parameter to reference a property or lineitem which has the list as dimension.
FINDITEM(List or Time, Item to find, [Property or Line Item to use for comparison])
We have different systems connected to Anaplan which have different codes e.g. for projects and I need this feature to identify them correctly without changing the code property on every import or creating help tables with cross mappings.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!