Help

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

Solved
Jump to Solution
730 0
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!