
1. Re: Excel Summary Numbers Differ from Filemaker
bigtom Aug 1, 2017 10:04 AM (in response to bookalaka)I have seen this happen when Excel is calculating and rounding numbers differently than FM. Ca you create a sample FM file with the data?
Have you manually done the calculation to verify which result is correct?

2. Re: Excel Summary Numbers Differ from Filemaker
bookalaka Aug 1, 2017 10:26 AM (in response to bigtom)I recently tried "ROUNDING" and that hasn't made a difference. Attached is FM file and the excel file I import.
The Import is simplified Category to Category and 2017 Case sales to YR_CASES_SOLD.
Thanks for looking at.

IGS_TEST_EXCEL.fmp12.zip 95.0 K

EXCEL_TEST_LA5.xls 38.5 K


3. Re: Excel Summary Numbers Differ from Filemaker
philipHPG Aug 1, 2017 11:01 AM (in response to bookalaka)1 of 1 people found this helpfulIn the Excel spreadsheet, how is the total of 3,684.37 being determined? It doesn't match the total of the lines.

4. Re: Excel Summary Numbers Differ from Filemaker
bookalaka Aug 1, 2017 11:32 AM (in response to philipHPG)That's a great question and something I never thought to verify. The report comes from my company and is an exported file from a program called QWIKVIEW. I have sent a request to see why this error is happening.
Thank you for pointing out.

5. Re: Excel Summary Numbers Differ from Filemaker
JimmyCox Aug 1, 2017 6:15 PM (in response to bookalaka)1 of 1 people found this helpfulEven in the excel you provided if you delete the total at the bottom of the excel list and replace it with a sum function, it gets the same number as FileMaker.

6. Re: Excel Summary Numbers Differ from Filemaker
philmodjunk Aug 1, 2017 6:22 PM (in response to bookalaka)This issue:
"As an example: FM shows the number 14 as 13.53000000000000469 when clicking in the field. Excel has the number as 14"
Has been around for a long time and is due to differences in precision between the two applications. If interested, you can search out a knowledge base article about it.