looking for some help here, hopefully someone can lend a hand.
My data look like this:
Manager Name - Associate Name - Scheduled Time - Actual Time
I have a calculated field that is saying if actual is > schedule then 0 else schedule minus actual. This returns a zero when someone works more than scheduled, but a positive integer when they work less than scheduled.
when the data is displayed by associate, this is fine, but when trying to sum by manager, it calculates the total scheduled time and subtracts the total actual time.
What I need it to do is to calculate for each associate and then sum the results.
What does the Lost Minutes calc look like?
Is there only one employee / row or do you need to aggregate at the employee level?
Maybe you could post a subset of your data in a sample packaged workbook.