SELECT() For a list top level item

ChrisAHeathcote
ChrisAHeathcote
in Modeling

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?

Tagged:

Best Answer

  • rob_marshall
    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.

     

    Rob

Answers

Categories