Set analysis not working correctly?

[#1]

Co Code	Batch ID	File #	Type	Reg Hours	O/T Hours	Hours 1 Code	Hours 1 Amount	Hours 2 Code	Hours 2 Amount	Earnings 1 Code	Earnings 1 Amount	Earnings 2 Code	Earnings 2 Amount	Temp Rate	Temp Dept	Shift	Pay #	Tax Frequency	Gross Receipts
		202		40.00	24.63		0.00
		202		37.91	0.00	PTO	16.00

Expressions:

Reg Hours:

 sum(aggr(if(sum({<[Hours Code]={''},[Paycor Time Off]={'0'}>}[Paycor Hours])>=40,40,sum({<[Hours Code]={''},[Paycor Time Off]={'0'}>}[Paycor Hours])),[Employee ID],[Paycor Week Ending]))

O/T Hours:

sum(aggr(if(sum({<[Hours Code]={''},[Paycor Time Off]={'0'}>}[Paycor Hours])>=40,sum({<[Hours Code]={''},[Paycor Time Off]={'0'}>}[Paycor Hours])-40,0),[Employee ID],[Paycor Week Ending]))

Hours 1 Amount:

sum({<[Hours Code]-={''},[Paycor Time Off]={'1'}>}[Paycor Hours])

With the above information, how is 37.91 showing up on the second line? Line 1 should show 77.91 but I do not know why it is not.

Edit:

Here is a table box with the values used above.

File #	Paycor Date	Paycor Week Ending	Paycor Hours	Hours Code	Paycor Time Off
202	2/13/2012	2/19/2012	8.00		0
202	2/13/2012	2/19/2012	9.50		0
202	2/14/2012	2/19/2012	11.18		0
202	2/15/2012	2/19/2012	10.15		0
202	2/16/2012	2/19/2012	10.33		0
202	2/17/2012	2/19/2012	10.27		0
202	2/18/2012	2/19/2012	5.20		0
202	2/20/2012	2/26/2012	8.00	PTO	1
202	2/21/2012	2/26/2012	8.00	PTO	1
202	2/22/2012	2/26/2012	9.93		0
202	2/23/2012	2/26/2012	11.15		0
202	2/24/2012	2/26/2012	10.80		0
202	2/25/2012	2/26/2012	6.03		0

[#2 · Accepted solution]

I found the solution. Adding Hours Code to the aggr seems to fix it.