cancel
Showing results for 
Search instead for 
Did you mean: 

Complex, Compound Filters

Highlighted
DC Motor
I need to filter my dataset to rows that have compound filter requirements.

For example, I want to find Sponsors who have each of these words in their name: "FUNDS", "INTERNATIONAL" and "LLC".  How do I set up such a filter.

The easiest (but not the only) way to do this is to create a computed column.  Here is the syntax:
AND(FIND("FUNDS",@SPONSOR@ )>0,  FIND("INTERNATIONAL",@SPONSOR@ )>0,  FIND("LLC",@SPONSOR@ )>0)

Once you have this field computed, use a filter on the computed column to isolate those rows that meet the complex condition.
Labels (1)
0 Kudos
0 Replies