OR Function in Filter Tool

[jaypee1217]

Does the filter tool require an IF(OR) statement? I have 2 separate filter tools and am trying to combine into 1 to clean up my workflow model. 

Filter Tool 1

[COLUMN1] != "397"

Filter Tool 2

!IsNull([AMOUNT])

I thought a simple OR would work, but it's not producing the correct results. 

[COLUMN1] != "397"

OR

!IsNull([AMOUNT])

[PhilipMannering]

Multiple Filter Tools is equivalent to having all of the statements in one tool separated by AND. Try that.

[COLUMN1] != "397"
AND
!IsNull([AMOUNT])

[jaypee1217 · Accepted solution]

Problem solved. Formula was working. My amount columns were not null and had trailing whitespaces.