Filter on Multiple Contains
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to filter on 2 criteria using contains. My customer filter's language is the following, but it is giving me errors. How do I correct this error?
Contains([PA_SUPPLIER_NAME],"CCP") OR Contains([PA_SUPPLIER_NAME]),"WFP")
Thanks
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@yzhang316 It looks like you have an extra parens in your second statement. try this:
Contains([PA_SUPPLIER_NAME],"CCP") OR Contains([PA_SUPPLIER_NAME],"WFP")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Facepalm...
Thank you so much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello, I have a similar issues and can't seem to write it correctly.
I need to do a sample excluding the following states.
!Contains([Property State],"New York") OR
!Contains([Property State],"New Jersey") OR
!Contains([Property State],"Pennsylvania")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think you should be using AND instead of OR
!Contains([Property State],"New York") AND
!Contains([Property State],"New Jersey") AND
!Contains([Property State],"Pennsylvania")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Say I want to filter on data that has values like " 1 - Asset" "2 - Liability" "3 - Equity" but I dont want to have to write out : [Account] IN ( " 1 - Asset", "2 - Liability", "3 - Equity") and I just want to be able to write: [Account] IN ("1", "2", "3").... that doesnt work because there is no value with just the "1". I have to write out the exact value.
I know there is also the option to write Contains ([Account], "1") OR Contains ([Account], "2") etc... but thats still alot of typing.
