SELECT() For a list top level item

ChrisAHeathcote

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?

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

ChrisAHeathcote

@rob_marshall 

Of course!

Thank you.