Hello All! 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. Any thoughts?