AnsweredAssumed Answered

Improve performance of eSQL aggregate function

Question asked by sccardais on Sep 17, 2015
Latest reply on Oct 8, 2015 by beverly

My file contains Paycheck data for each payroll period over the past 3 years.

 

A calculation field c_SumByYear summarizes the amount of each check (GrossPay) and groups the total by year. The calc also rounds the GrossPay to remove decimals and replaces the commas between the fields with hyphens for formatting purposes.

 

The field is currently configured as a global. The calculation works but it is painfully slow.

 

Any advise on ways to speed this up would be appreciated.

 

Substitute(

ExecuteSQL ("SELECT paychecks.cyear

, SUM (ROUND(paychecks.GrossPay,0))

FROM Paychecks

GROUP BY paychecks.cyear";"";"")

; ","

;"—-"

)

Outcomes