AnsweredAssumed Answered

Precision changes on import

Question asked by kayakjunkie on Sep 17, 2013
Latest reply on Sep 17, 2013 by philmodjunk

Title

Precision changes on import

Post

     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.

Outcomes