filtering multiple fields

[lancegoh1]

hi can someone guide me as to how do I filter multiple fields?

I keep getting an error "Contains Requires 2 or 3 arguments. here is my filter expression".

Contains([F22],"Manual Check")
&&
!Contains([F23], "CSM","DC","MO-AO","PAY","Undefined","MO-ICF","MO-SOKO")       
&&
Contains ([F11], "null")

[ADerbak · Accepted solution]

Hi @lancegoh1!

Your 2nd Contains statement has too many arguments. You should switch that to  "[F23] NOT IN ("CSM",...)".

Also, I am not sure if F11 is supposed to have NULL values or if "null" is the value, but the difference will change how you filter that field. If it is truly NULL values, then use isNull([F11]). Otherwise, your Contains statement should work.

I hope that helps!

-AD

[lancegoh1]

wow Thanks!

Regards,

Lance