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 :slightly_smiling_face:
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.