Re: How to calculate Total money bet using PT?
If you've converted your databases to postgresql, you can put the following query in the SQL window
select sum(total_bet) as TOTAL_BET, sum(total_won) as TOTAL_WON, sum(total_won-total_bet) as NET_WON from game_players inner join players on players.player_id = game_players.player_id where players.screen_name = 'Pokerpun'
Replace Pokerpun with your screen name, leave the ''. If you don't have postgresql, it's a bit more complicated. It's probably easier to install postgresql and convert the database than anything else.
|