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?

Best Answer

  • rob_marshall
    Answer ✓

    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.