Custom Filter using Contains In

[elclark]

Hello,

I'm trying to filter a field for multiple criteria so if it has any of these codes, it should be in the population. I tried this expression in the customer filter section but that's not working. I'd rather not do multiple Contains OR statements because I have sometimes a very large number of criteria to filter by.

Contains([Field] IN (5000, 5001, 5002, 5003, 5004, 5005, 5006, 5007, 5008, 5009, 5010))

[atcodedog05 · Accepted solution]

Hi @elclark 

Contains cannot be used this way. Contains can only be used this way

If its exact code in the fields you can directly use.

[Field] IN (5000, 5001, 5002, 5003, 5004, 5005, 5006, 5007, 5008, 5009, 5010)

Hope this helps 🙂

[elclark]

I'm not sure what you mean by your last statement

"If its exact code in the fields you can directly use.

[Field] IN (5000, 5001, 5002, 5003, 5004, 5005, 5006, 5007, 5008, 5009, 5010)"

[atcodedog05]

Hi @elclark 

If field = 5000 or field = 5001....

Then you can use in like mentioned. Or else you In.

You need multiple contains with IN.

[elclark · Accepted solution]

I see, thanks! It wasn't working at first and realized I had to add the quotations like I listed below and now it works.

[Field] IN ("5000","5001","5002","5003","5004","5005", "5006","5007","5008","5009","5010")

[atcodedog05]

Glad to hear you figured it out 🙂 

Happy to help 🙂 @elclark 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂