AND Not in a Single Custom Filter

[Inactive User]

Hi,

I am working on extracting the Vendor names that not already in my list so I can add them into my database.

So filter condition should be:

Vendor Name (Amended) = NULL

AND

(Vendor Name Should not be 0 AND Vendor Name Should not be 'Unavailable' AND Vendor Name Should not be Blank)

For some reason, below filter condition is not working and I am getting a parse error. Please advise.

[vizAlter · Accepted solution]

Hi @Inactive User — Looks that [Vendor Name] field has string data type, so write "0" instead of just 0