Bin size not correct for paid time off hours per employee?

33 Views Asked by At

I have a workbook with employee time off hours. The hours are in a field called [Approved]. I wanted to get a count of days (approved hours / 8 = 1 day of PTO) employees were taking and Bin them.

{ FIXED [Employee ID1]:SUM([Approved])/8}

and then I created Bin sizes of 10. It seems like the correct way to go about it, but for some reason it's showing 2022 had employees with 80+ days off.

enter image description here

but when you look at the data to show employee days (approved hours / 8), it shows the most an employee had was 71 days in 2022:

enter image description here

any ideas what I could be doing wrong?

0

There are 0 best solutions below