True/False Filter not rendering right

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?

Workflow

Accepted answers

binu_acs

@rockeylearning try the below formula in the filter condition

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

All comments

binu_acs

@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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703