Filter Tool OR formula -- What am I doing wrong??

Question

!IsNull([Amount]) or [Amount] != "Amount" or !Contains([Amount],"#")

Each part works independently, so I can just get what I need from three filter tools but is there a way to use one and combine it? What is the best practice on this?

Snag_454ed12.png

MarqueeCrew · Accepted Answer

@Raychrls ,

OR is your issue.

!IsNull([Amount]) lets anything pass the subsequent tests.

I think that you want AND instead of OR

Cheers,

Mark