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
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