Filter Function

[Cferrer6]

Hello, 

I am trying to create a filter to only send emails if the report contains certain criteria. I do not want to send areas 21-24 however the below filter i created didn't work. Screen shots attached. Any suggestions?

[Area] != "21"
OR
[Area] != "22"
OR
[Area] != "23"
OR
[Area] != "24"

[echuong1]

You'd want there to be an "and," not "or."

Another way of writing it is below:

[Area] not in ('21','22','23','24') 

[Cferrer6]

thank you so much

What about if i only want areas 21-24?

[echuong1]

With the way the filter is written, anything other than 21-24 will come out of the T output. Anything 21-24 will come out of the F output.

[Cferrer6]

thank you, what is its a new filter needing the following though (different filter)

Give me when email invoice =yes, cad=no, call listing = Y Area= 21-24 only

[Email_Invoice] = "Y"
AND
[CAD] = "N"
AND
[CallListing] = "Y"
AND
[Area] = "21"
AND
[Area] = "22"
AND
[Area] = "23"
AND
[Area] = "24"
AND
[Type] != "F"

[echuong1 · Accepted solution]

The end of your syntax is the issue. It is impossible for a record to have an Area = to all 4 of the values, you'd actually want those to be a separate condition with or in between. This can be achieved by wrapping it in parenthesis.

Try this:

[Email Invoice] = 'Yes'
and
[CAD] = 'No'
and [Call Listing] = 'Y'
and
[Area] in ('21','22','23','24')

If this resolves your issue, please mark this thread as solved so others can find answers more easily. Thanks!

[Cferrer6]

thank you so much it all worked perfectly!