Function not working in expression GetFieldSelections('$(=

[Fabien]

Hi all,

Please forgive my ignorance if this is a silly question, but this really got me stuck and i fail to understand why...

=if(GetFieldSelections('$(=If(SHIPCOMP_NAME='-',Null(),SHIPCOMP_NAME))')=('ANL'),SCOPE,'Not available for this Carrier')

If you ask why i am using: '$(=If(SHIPCOMP_NAME='-',Null(),SHIPCOMP_NAME))' it is simply because I have set filter panes althroughout my app with the same expression, however considering i am still not getting the correct result, i probably should stick to the below (that doesn't work either):

=if(GetFieldSelections(SHIPCOMP_NAME)=('ANL'),SCOPE,'Not available for this Carrier')

Thanks for any enlightenment you could give me! 😁

[UserID2626 · Accepted solution]

if you select more than one value your condition will fails, because get filed selection will pick all the values selected from that field.

=if('$(=GetFieldSelections(Date))'=('ANL'),'SCOPE','Not available for this Carrier')