community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

In between two sets of numbers

Asteroid

Hi,

 

I am trying to write a in between formula in the "Filter" drop down, but running to some issues...please help.

 

The filtered result should be: 

5,000 to 10,000 and 12,000 to 15,000

 

This is my formula, but it's not working...

ToNumber([Cost])>5000 AND ToNumber([Cost])<10000 AND ToNumber([Cost])>12000 AND ToNumber([Cost])<15000

 

Thank you

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @yzhang316

Try this:

(ToNumber([Cost])>=5000 AND ToNumber([Cost])=<10000) OR (ToNumber([Cost])>=12000 AND ToNumber([Cost])=<15000)

 

Cheers,

Asteroid

 

 

Thank you!

Labels