I am using Filemaker Pro 6 and have had this problem for a while but was wondering if there was a way to speed this up another type of calculation. I have a simple calculation that creates a sum of invoices and sum of payments and then subtracts the two. We have alot of problems scrolling through customers because this calculation can take a long time (especially if there over 80 invoices for that customer) and if i want to run a report for total dues over $1000 on the total due field it takes almost a hour!
Total Invoices Calcuaation = SUM(INVOICES:Total Invoice Amount)
Total Payment Calculation = SUM(Payments:Total Payment Amount)
Total Due Calculation = SUM(INVOICES:Total Invoice Amount) - SUM(Payments:Total Payment Amount)