Precision changes on import
I have a column of numbers in Excel that all have 2 decimal places.
When I import them into Filemaker, most import fine, however about 1/4 of them do not enter with the correct precision. For example, 10.20 becomes 10.1999999999999. This seems to be causing sub-summary reports to fail.
Instead of a rounded amount, the field is showing up in the report as a ?
What is up?
I was able to correct this by modifying the layout and requiring the data field to be 2 decimals, however, I'd like to know why it is not importing the correct value.