In between two sets of numbers

[yzhang316]

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

[Thableaus · Accepted solution]

Hi @yzhang316

Try this:

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

Cheers,

[yzhang316]

Thank you!