Filter Tool to Remove Multiple Criteria

[Fescobar]

Hello Community,

I am running a pretty long formula and I am getting false positives due to garbage data entries.  My problem is that I am not too familiar with the custom filter option on the Filter Tool.

I am looking to remove all entries with invalid data such as 99999999999, 8888888888, 7777777777...so on and so forth at the data entry point.

Thank you!!

FEscobar

[Fescobar]

Solution found.

[pedrodrfaria]

Hi @Fescobar 

It is great that you were able to find the solution for your question. 

One way you can do this is to this filter below:

[Field1] != '99999999999' and
[Field1] != '8888888888' and

[Field1] != '7777777777' 

Pedro.

[pedrodrfaria · Accepted solution]

Hi @Fescobar 

It is great that you were able to find the solution. For educational purpose and for other people with similar questions, see below for my attempt

Filter Tool:

[Field1] != '99999999999' and 

[Field1] != '8888888888' and 

[Field1] != '7777777777' 

Let us know if your solution looks different.

Pedro.