Filter tool: comes after 90 does not work

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???

Help

Accepted answers

alexnajm

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!

gautiergodard

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

All comments

alexnajm

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

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!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280