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])
Solved! Go to Solution.
Multiple Filter Tools is equivalent to having all of the statements in one tool separated by AND. Try that.
[COLUMN1] != "397"
AND
!IsNull([AMOUNT])
Problem solved. Formula was working. My amount columns were not null and had trailing whitespaces.
User | Count |
---|---|
103 | |
81 | |
66 | |
49 | |
40 |