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.
Jan 14, 2020 06:43 AM
I have a width entry and a height entry entered in columns
W cm [defined as a number field with precision 2 decimal places]
H cm [defined as a number field with precision 2 decimal places]
I have a formula to bring these together into one field:
{W cm} & " x " & {H cm}
Result is incorrect because …
19.68 25.08
Becomes
19.685 x 25.0825
Can anybody tell me why this is happening please?
Jan 14, 2020 07:32 AM
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!
Jan 14, 2020 08:26 AM
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?
Jan 14, 2020 08:27 AM
By the way … it’s not happening consistently
Jan 19, 2020 12:34 PM
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?
Jan 19, 2020 01:45 PM
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.