AnsweredAssumed Answered

Reducing calculation over head.

Question asked by rp2524 on May 28, 2012
Latest reply on May 31, 2012 by steve_ssh

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.

Outcomes