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!

[ChrisTX]

Can you post a workflow with sample data?

If you're trying to specify True or False in a Filter tool, use:

IF [Max_Total]=[Max_F9] THEN 1 ELSE 0 ENDIF

//1 = true

//0 = false

[isacaso18]

Hello I tried this and look

It is filtering it through "F" when it should be filtering through "T".

[TheOC]

hey @isacaso18 

I believe i have created the filter how you need it, however its slightly hard to understand the problem. Please have a look at my solution, and let me know if this works.

Thanks,
TheOC

[isacaso18]

Hello,

it is still displaying it as False.

[TheOC]

Are both of your datatypes numeric / doubles?

Can you package a workflow with your data (or, just this row of data) so i can test with the exact same setup?

Cheers,
TheOC

[binuacs]

@isacaso18 Try something like below and see the output

Trim([max_total] = Trim([max_f9]

[isacaso18]

I also tried adding the parenthesis at the end and it would not work.

[Luke_C]

Hi @isacaso18 

Add closing parenthesis.

Trim([max_total]) = Trim([max_f9])

[patrick_digan]

@isacaso18 Unfortunately, alteryx doesn't always show you the actual number that is saved behind the scenes. I suggested 5 years ago that they add an indicator to alert the user and show the actual number. https://community.alteryx.com/t5/Alteryx-Designer-Ideas/visual-indicator-actual-value-anytime-displa...

Off the top of my head, you might want to round both numbers Round(max_Total,.01) or take the abs of the difference and make sure that it's really small ABS(Field1-Field2)<.0000001