Filter tool: comes after 90 does not work

[rhearns1]

I am using the Filter tool to remove anyone with a systolic BP less than 90.  I tried the basic filter "comes after 90" within the tool but it then will only provide those patients with a BP between 90 and 99.  It excludes anyone in the hundreds plus.

Then I tried using the Custom filter of "[BP Systolic] > "90" OR [BP Systolic] > "100" I did receive all the 90s and from 101 but any patient that had 100 was excluded.

What am I doing wrong???

[alexnajm · Accepted solution]

This looks to be an issue with your data types - aka [BP Systolic] should be numeric. I would change it beforehand using a Select tool and then remove the quotes from your Filter!

[alexnajm]

[BP Systolic] > 90

OR if you need to keep the data type for some reason... try ToNumber([BP Systolic]) > 90

[gautiergodard · Accepted solution]

Hello @rhearns1 

Firstly, can you please double check to ensure the data type of your BP Systolic field is a numeric data type (double, int, etc..)?

From there, if you want to remove anyone with a systolic BP less than 90 you would do:

[BP Systolic] > 90

If you want to remove a systolic BP less than or equal to 90 you would do

[BP Systolic] >= 90

[rhearns1]

Thank you both, my field was listed as General not numeric.  

[rhearns1]

Okay, I made the input workbook field to a number.  Saved it and corrected the query.  But still had the same problem.   Then I added the select tool and it worked.

THANK YOU BOTH for your assistance!