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.
ExecuteSQL ("SELECT paychecks.cyear
, SUM (ROUND(paychecks.GrossPay,0))
GROUP BY paychecks.cyear";"";"")