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.