The true value of {H cm} is actually 25.0825, but it’s showing a display value of 25.08.
There’s several approaches to solving this. If {H cm} is a formula, I’d recommend using the ROUND() function within that field so that your summary bars don’t get thrown off (though, this might not matter if you don’t use them).
If {H cm} is not a formula, use the ROUND() function in the formula you’re asking about.
ROUND({W cm}, 2) & " x " & ROUND({H cm}, 2)
Hope this helps!
I am confused as to why a number field becomes a different number in a function call field?
{W cm} is a number field with 2 decimal places as is {H cm}. Why is the function field mangling the numbers?
I am confused as to why a number field becomes a different number in a function call field?
{W cm} is a number field with 2 decimal places as is {H cm}. Why is the function field mangling the numbers?
By the way … it’s not happening consistently
I am confused as to why a number field becomes a different number in a function call field?
{W cm} is a number field with 2 decimal places as is {H cm}. Why is the function field mangling the numbers?
Hi there - sorry for the delay, I wasn’t notified of your reply to this post.
The function is not mangling the numbers, math is
Can you give more information on how your getting to the numbers in question? Are they manually entered into a Number field? Or are they calculated via a formula? If it’s a formula, can you share the formula?
I am confused as to why a number field becomes a different number in a function call field?
{W cm} is a number field with 2 decimal places as is {H cm}. Why is the function field mangling the numbers?
Yep - extremely annoying and I think this is the infamous floating point bug which was first documented in 2017 and as far as I know, remains until this day.