July 28, 2014 at 7:34 pm
OK so I have a report that I need to hand over tomorrow, so any quick responses will greatly be appreciated!
I have been working on this the whole day and still haven't been able to figure it out, partially because I am a beginner at this.
Here is my scenario:
I have a matrix report that returns something similar to the following data:
ProjectName, EmployeeName, SalaryStatus, TotalWorkHours, NormalizedHours, Week1, Week2, Week3, Total, Costs/Paid
01-ABC, Mark, Exempt, 100 (this is derived from adding up the total hours for each week), 10,10,10, 30 $1500
01-ABC, Tom, Exempt, 80, 20,10,10, 40 $2000
01-ABC 180, 70 <<<<<<<<<<<<<<<<<<<<<<TOTALS for specific project
02-XYZ, Rick, Non-Exempt, 90 20, 20, 20 60 $900
02-XYZ, Grace, Exempt, 30 10, 20, 10 40 $1000
02-XYZ 120, 100
So what I really need help with is deriving the TotalWorkHours for each project and employee but my groupings are not working correctly.
Also a plus point would be to be able to add up the normalized hours for the week with a total column as well. Please ask me if this is not clear enough. Thank you.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply