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))
Solved! Go to 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 🙂
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)"
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.
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")
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 🙂