SELECT() For a list top level item

Hi All,

I am trying to use SELECT to pull through the top level value so I can create a phasing profile to push a single value down a hierarchy.

I thought this would be possible but I am getting an error saying that the reference is not recognised.

How have others managed to achieve the same outcome?

Accepted answers

rob_marshall

Hey @ChrisAHeathcote

Select should work IF the top member is a true top member of the list and not the first member with the name of "All". Also, if it is a composite list, make sure you are doing the select on the top member of L1 and not Lx.

Rob

All comments

Rob

Of course!

Thank you.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…