True/False Filter not rendering right

[rockeylearning]

Hi Community!

I am running into a weird issue with Filter tool. 

My Filter is checking if [Transaction Amount] = [Detail Line Item Amount], it's working for every records, except for one record that fall into False (second screenshot). 

The value look exactly the same, I use Data Cleanse to clean up any white space, leading trails before do the Filter

I can't tell why it happening to just one record. Anyone experienced something like this before?

[binu_acs · Accepted solution]

@rockeylearning try the below formula in the filter condition

Round([Transaction Amount],0.01) = round([Detail Line Item Amount],0.01)

[rockeylearning]

@binu_acs you're a life saver! Thank you, it worked!

How can I tell if Alteryx is not rounded the number? Round vs Not, can this be prevented?

[binu_acs]

@rockeylearning IF you actually look at the value of [Transaction Amount] for the mismatch amount in the cell viewer it might be something like below 3226802.07888888 that is why it was not matching, when you do the rounding it will only consider the 3226802.08 in both the values, this cannot be prevented