Restricting field values shown in a multi box

[Anonymous]

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.

[Anonymous]

may be like this:

=if(_View <> 'Patent Analytics' or _View <> 'FDA Analytics', _View)

[tresesco · Accepted solution]

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.

[Anonymous]

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

[Anonymous]

Many thanks Tresesco, that works well

[ahmar811]

try this

If(Match(_View, 'Patent Analytics' , 'FDA Analytics') =0, _View)

hope this help you

Regards

Ahmar

[Anonymous]

Thank you Ahmar