We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Raychrls
7 - Meteor

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

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Raychrls ,

 

OR is your issue.

 

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

 

I think that you want AND instead of OR

 

Cheers,


Mark

 

 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Raychrls
7 - Meteor

Tusen takk!

Labels
Top Solution Authors