Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Why are these numbers not equal, when they actually are?

Solved
Jump to Solution
2674 3
cancel
Showing results for 
Search instead for 
Did you mean: 
BobBannanas
6 - Interface Innovator
6 - Interface Innovator

I have tried wrapping both fields in VALUE(field), ABS(field), etc.

How do I get this to behave?

What is the reasoning behind this?

Snipaste_2019-07-07_22-00-35

1 Solution

Accepted Solutions
W_Vann_Hall
13 - Mars
13 - Mars

Hard to tell from what you show here.

There is a known Airtable bug having to do with implicit conversions during comparisons that might be raising its ugly head here.

Alternatively, depending on how the field that is referenced by {[moneybag]Received} is derived — or, for that matter, the original source for {[infinity]Received} — you might be comparing values with a different number of significant digits. Try wrapping both in ROUND({Field},2) to see if it helps. You could also try changing the formatting for both fields to decimal with 3 or more significant digits to see if the values are, indeed, the same.

See Solution in Thread

3 Replies 3
W_Vann_Hall
13 - Mars
13 - Mars

Hard to tell from what you show here.

There is a known Airtable bug having to do with implicit conversions during comparisons that might be raising its ugly head here.

Alternatively, depending on how the field that is referenced by {[moneybag]Received} is derived — or, for that matter, the original source for {[infinity]Received} — you might be comparing values with a different number of significant digits. Try wrapping both in ROUND({Field},2) to see if it helps. You could also try changing the formatting for both fields to decimal with 3 or more significant digits to see if the values are, indeed, the same.

W_Vann_Hall Strikes again! Perfect solution!!. :slightly_smiling_face:

BrighterPage
4 - Data Explorer
4 - Data Explorer

This has been perplexing me for ages—thank you!