Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Float point number field issues

SS40
Tera Expert

Hi, I have a field in the form of a Floating point number type. If I put any value to that field and save the record, it gets converted to 0.99999999.

 

What could be the issue?

 

1 REPLY 1

Chetan Mahajan
Kilo Sage

Hello @SS40 ,

                       Floating point numbers are stored in binary format, which can sometimes result in rounding errors when converting from decimal to binary and vice versa. To avoid this issue, you can change the field type to "Decimal" instead of "Floating point number"

                            Please refer this Article How to configure floating point decimal accuracy on decimal fields.

Kindly mark correct and helpful if applicable