Filter Tool not working

[isacaso18]

I gathered the Max of two columns (by using the summarize tool) so they are called [Max_Total] and [Max_F9]. I want to use the filter tool for the information to filter through "T" if they match and "F" if they do not match.

I tried using the custom filter:

[Max_Total]=[Max_F9]

When the values match it filters it through the "F". I changed one of the values for them to mismatch and it filtered the mismatch values through "F". So it is filtering them both, whether they match or do not match through the "F".

I also tried this one:

[Max_Total]!=[Max_F9]

And it filters both matching and mismatching values through "T". 

I also tried with the 

IF [Max_Total]=[Max_F9] THEN "T" ELSE "F" ENDIF

and viceversa and it still does not work. Someone help!

[isacaso18]

[ChrisTX]

More people may be able to help you, instead of guessing at a possible cause, if you could upload a workflow with sample data.

Each field's data types make a significant difference in how Alteryx processes the data.

My first suggestion was:
IF [Max_Total]=[Max_F9] THEN 1 ELSE 0 ENDIF

When you add double quotes around the 1 and 0, Alteryx will act differently.