Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculating Sick Time
Thanks Pete. When I move the formula I am getting the correct total hours worked. Thank you! When I look at my report I got 80 hours for Baker as well so I am not sure what happened there. Thank you for your help with this! Peggy- POrlowski
- Post #8
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Calculating Sick Time
Attached is The report with saved data. I think that the one I have in green is working but I put yours in as well in grey. The report is run from 1/1/2023 through 7/2/2023. Payroll dates only show up if they have hours for that week. So I also had to check if the last date of the report was...- POrlowski
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Calculating Sick Time
It did not work. I apologize If I was not clear, but you have your hours in the detail section my hours are in Group 2 I have attached a snip of what my set up looks like and how I changed the formula you cage me. Your formula is only returning the hours they worked each week and never...- POrlowski
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Calculating Sick Time
I am working in Crystal Reports connecting to an SQL database. When calculating sick time you take the total hours worked and divide it by 30 to get sick time. The issue is if the employee does not work a week then their total hours start all over again. Group 1 is Employee Group 2 is Payroll...- POrlowski
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 1 Formulas
