Here is a little twist they put into it.

Point system, meaning if the employee has 0 pts for the month and they have points in the rolling total column they would like to take one point away for good behavior but if there are NO points they receive nothing.
One point is ONLY removed IF the employee has perfect attendance and IF they have a number in their rolling points column.

I was thinking of adding another column for Perfect Attendance?
Ideas?