True/False Filter not rendering right
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@rockeylearning try the below formula in the filter condition
Round([Transaction Amount],0.01) = round([Detail Line Item Amount],0.01)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs 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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
