Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a multi box with the following fields and corresponding values:
If i want to exclude 'Patent Analytics' from showing in the multi box, i am using the following expression for the multi box:
=if(_View <> 'Patent Analytics', _View) with the following results where this field value has been excluded from the multi box.
How do i exclude multiple field values, say i want to add 'FDA Analytics' and 'Shopping Analytics' to the exclusion list, what will be the resulting expression like?
Regards.
For multi-value comparison match() is a better option. try like:
If( Not Match(_View, 'Patent Analytics' , 'FDA Analytics') , _View)
You can put as many values as you want in match() to compare.
may be like this:
=if(_View <> 'Patent Analytics' or _View <> 'FDA Analytics', _View)
For multi-value comparison match() is a better option. try like:
If( Not Match(_View, 'Patent Analytics' , 'FDA Analytics') , _View)
You can put as many values as you want in match() to compare.
Many thanks Balraj, the recommendation does not work, with that, the multi box lists 'Patent Analytics' as the only field value although it should be excluded.
regards
Many thanks Tresesco, that works well
try this
If(Match(_View, 'Patent Analytics' , 'FDA Analytics') =0, _View)
hope this help you
Regards
Ahmar
Thank you Ahmar