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

[Raychrls]

!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?

[MarqueeCrew · Accepted solution]

@Raychrls ,

OR is your issue.

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

I think that you want AND instead of OR

Cheers,

Mark

[Raychrls]

Tusen takk!