1 Reply Latest reply on Sep 17, 2013 11:43 AM by philmodjunk

    Precision changes on import

    kayakjunkie

      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.