6 Replies Latest reply on Aug 1, 2017 6:22 PM by philmodjunk

    Excel Summary Numbers Differ from Filemaker

    bookalaka

      Hello and thank you for the help.

       

      I am having a discrepancy from my summary totals in Filemaker in comparison to Excel? The files I work with are exported from my Company file to Excel and then I import to manipulate the data. Attached is a file showing that the FM is shorting me 199 units in the summary field? Why are the numbers so different?

       

      I kept thinking I had deleted data and this was the cause for the summary difference. After numerous checks I discovered no records were deleted so I decided to export my information back into excel and compare to the data that was originally imported and discovered this anomaly.

       

      As an example: FM shows the number 14 as 13.53000000000000469  when clicking in the field.  Excel has the number as 14

       

      My file shows the numbers I get from FM and the Excel total

       

      I need a sum of  total cases sold. Am I missing a setting? The difference is quite substantial.

       

      Thanks for the help