Float point number field issues
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2023 09:55 PM
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?
- Labels:
-
Incident Management

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2023 10:00 PM - edited 03-22-2023 10:03 PM
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