Custom Filter

[kadenemcintosh]

I want to filter a series of account number from a list ranging from 47000 thru 49000. What is the exact formula to use? Keep getting a Parse error.

[Thableaus · Accepted solution]

Hi @kadenemcintosh 

If your Account Number is a String, you could use this

ToNumber([Field]) >= 47000 AND ToNumber([Field]) <= 49000.

That should work.

Cheers,

[kadenemcintosh]

After I filter and have range of accounts. I want to pull only specific accounts next using another filter.

Account 47000 and 48000 only using another filter.

[Thableaus]

@kadenemcintosh 

Use this:

ToNumber([AccountNumber]) IN (47000, 48000)

Cheers,