To be able to offer any help would require that you reveal the driving record on your report, and the actual details of the LASD Total formula, and the list of data files contributing to your report.

Of course. :) The Primary record is PR Employee Pay.

The LASD Total Formula is LASDSKCAPT (Design Formula) + Sick Acc Prior Yr (Design Formula)

LASDSKCAPT formula = IF(Pay ID (PR Employee Pay) = "LASKCAP", YTD Units (PR Employee Pay)) + IF(Pay ID (PR Employee Pay) = "SDSKCAP", YTD Units (PR Employee Pay))

Sick Acc Prior Yr formula = IF(Payr ID (PR Employee Pay) = "LASDSK_CO", YTD Units (PR Employee Pay))

Are you calculating this formula during check processing? If so, the driving record must be the check record

I see. The formulas are in Report Designer, not in Payroll, however the LASKCAP and SDSKCAP pay ids do have a formula in Payroll. Will that require the driving record to be check record? Thank you for your help. Trying to accommodate Los Angeles and San Diego's new city-specific sick accruals and caps has stretched me into areas where I only have limited experience.

If your calculating the vac accrual as a fringe during payroll processing, the check record must be the driving record. If you're running a report after payroll processing and you haven't accrued the vac during payroll processing but merely want a report to manually calculate it, I would still recommend using the check record and use a lookup formula. Not in front of a computer right now so can't refer to the data dictionary for specifics.

Thinking about your issue further, it would be helpful to clearly state the purposed of your report, and the underlying data structure. Here's what I've concluded thus far:

You accrue sick hours for both LA and SD county employees or work done by employees in two counties. True or False?
You use different Pay IDs for accrued sick hours for San Diego and Los Angeles and an employee could work in both locations, True or False?
Each employee could have accrual Pay IDs for for both LA and SD accrued sick hours. True or False?

Your accrual formula that accrues these hours during payroll processing does not test for a limit and cut-off the accrual when the limit is reached and allows sick hours to be accrued in excess of the mandated cap. True or False?

Therefore, you need a report that pulls the actual accrued hours (units) for up to two sick hr pay IDs for each employee with the report imposing a limit on hours (units) reported to no more than 80. True or False?

Have you chosen to SUMMARIZE the output by employee to report only one line per employee, or are you listing each of the two accrual pay IDs for each employee?

If you are are summarizing by employee, you will likely need to use the ASUM function in your formulas to do the math.

Your situation is more detailed than is easily solved in a forum like this. If you would contact me through private message or email, and forward a printout of your report design, I could very quickly focus on a solution to your issue.

Art Minds
Pasadena, CA
[email protected]