Date: 08/15/08 (SQL Server)    Keywords: software

Hi. I am currently using a stripped-down version of CR 8.0 integrated into a software platform called SysPro.

I'm trying to pull out some timecard information for multiple people, organized by employee, then date, then job#. I've put it in and all of the names and times are pulling correctly.

HOWEVER. I also need to calculate the Regular Pay Time and Overtime from these numbers. Currently, I've got a Summary of my Total Time (which is calculated from four different time fields in each record) in my Group #1 Footer, which gives the correct amount of total hours.

What I'd like to do is create two formula fields that calculate out RT and OT (regular time<=40 hours).

What I imagine for these fields is something like the following:
Regular time: if {Sum of @Total Time} > 40 then "40"
Overtime: If {Sum of @Total Time} >40 then {@Total Time} - 40

Of course, the problem here is that I cannot insert a Summary field into this equation the way I would a calculation field.

Anyone have any ideas? Help would be greatly appreciated.

Source: http://community.livejournal.com/sqlserver/66825.html