Free Trial

Alteryx Designer Desktop Discussions

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

OR filter is not working, cant figure it out///

Dan5
8 - Asteroid

I have a fairly simple custom filter:

 

[Opportunity] > [Min_deal_size] or [ARR]>0 or [Pipeline] >0

 

However the output still contains records that match this next filter:

 

[Pipeline] = 0 && [ARR] = 0 && [Opportunity] < 10000

 

 

10000 is the value of my Min_deal_size fyi. 

 

I am pulling my hair out...thanks!

2 REPLIES 2
binuacs
21 - Polaris

@Dan5 can you provide some sample data to verify ?

Qiu
21 - Polaris
21 - Polaris

@Dan5 
Better to have some sample data.
Since you are use OR, given your data nature, it may end up the results looling like a different filter.

Labels
Top Solution Authors