I have a solution that tracks billing / invoicing. I have a calculation that tracks Billables and it’s slowing down my solution. Total Bilable is a calculation field :

**If ( DateJob ≥ Date ( 5; 1; 2011) and PickType = "Worked" and T15c_products_INVOICE_LINE_ITEMS||id_products|::Status_Billable ≠ "1"; (PayTotal + CalM_Bill_Payroll_Town + CarTotal))**. I also Summarize the field, which is where I see it slowing down the solution. Can someone give me alternative way to write the calculation to reduce the over head? This is my first attemt at posting, so please excuse any error in etiquette.

FileMaker needs time time to perform calculations, there is no way around this problem. There are a couple of ideas:

get faster hardware to perform the calculations in less time

compute the calculations and remember the result so it never gets calculated again

The second option is only possible if the data never changes, or changes infrequently. If it changes there needs to be a process to re-calculate else inaccurate data gets presented to the user.