Custom Filter Expression

[k3pineapple]

I would like to simply the Custom Filter scripts here, wondering whether there is way.

E.g.

[Application] = "a" AND

[Application] = "b" AND
[Name] != "smith" AND
[Name] != "peter."

Is there a way to Omit the repetitive part, in this sample, which are [Application] =  [Name] !=

Tried with [Name] != ("smith" , "peter"), no luck

[alexm06 · Accepted solution]

@k3pineapple I think you're along the right lines. The IN and NOT IN functions might be what you're looking for here. Does the following solve your problem?

[Application] IN("a","b") AND
[Name] NOT IN ("smith","peter")

[k3pineapple]

Yes, that's the function I am looking for, thank you