SELECT() For a list top level item

ChrisHeathcote
Community Boss

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?

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
1 ACCEPTED SOLUTION

Accepted Solutions
rob_marshall
Moderator

Re: SELECT() For a list top level item

Hey @ChrisHeathcote 

 

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

View solution in original post

2 REPLIES 2
rob_marshall
Moderator

Re: SELECT() For a list top level item

Hey @ChrisHeathcote 

 

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

View solution in original post

ChrisHeathcote
Community Boss

Re: SELECT() For a list top level item

@rob_marshall 

Of course!

Thank you.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA