Gross won/Lost stats

[roundar]

I'm working w/ gross won/lost stats I've made and have one set of stats that aren't adding up the way I'd expect them to. I have two stats for gross won/gross lost. When I subtract gross lost from gross won I get an exact match of "My C Won" stat. This is what I expected. Then (for tax purposes. Does this already exist somewhere I don't see?) I created gross won in sessions I won and gross lost in sessions I lost. When I subtract lost from won here, I receive an amount greater than "My C won" by about 1%.

Here are the columns, I can include the stats themselves if necessary:

Gross won/lost:
sum( if[ cash_hand_player_statistics.amt_won > 0, cash_hand_player_statistics.amt_won, 0 ] )
sum( if[ cash_hand_player_statistics.amt_won < 0, cash_hand_player_statistics.amt_won, 0 ] )

Gross won/lost in sessions won/lost:
sum( (SELECT if[ chps_s.amt_won > 0, chps_s.amt_won, 0] FROM cash_table_session_summary chps_s WHERE chps_s.id_session = cash_hand_player_statistics.id_session AND chps_s.date_start=cash_hand_player_statistics.date_played) )

sum( (SELECT if[ chps_s.amt_won < 0, chps_s.amt_won, 0] FROM cash_table_session_summary chps_s WHERE chps_s.id_session = cash_hand_player_statistics.id_session AND chps_s.date_start=cash_hand_player_statistics.date_played) )

[WhiteRider]

It's possible that if you played past midnight in some sessions then the date of the start of the session and the date the hand was played may not match. I suspect that is where the difference is coming from.