A question about totaling and summing with Crystal Reports
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.
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.
