Visual Ignoring Advanced Filtering

[Anonymous]

I have a visual as shown below. I am attempting to use advanced filtering to get rid of any invoices with the prefix of INMAR and DS. As one can see, it does not seem to be filtering out the INMAR invoices (it is not filtering out DS invoices either but I couldnt include them both on this screen shot). I have used Advanced filtering with sucess before, I cannot seem to figure out why it is not working.

Thanks in advance!

[Anonymous · Accepted solution]

Hey @Anonymous

You need to switch the OR to AND. OR won't filter out either because INMAR does not start with DS and DS does not start with INMAR. Kind of confusing...

Hope this helps,

Parker

[Anonymous]

That is a little confusing. But thank you I will keep this in mind!