Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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