Is there a column in the database which tells me the amount of the call as a very last action on the river?
I mean: For example I bet the river with $200, my opponent raise to $600, I call. "tourney_hand_player_statistics.amt_bet_r" gives $600 for me as my total action. Is there a column which stores the amount of my last call only? ($400 in this case.)
If there isn't, how I can create that as a custom stat?
The amount you have to call (specifically: the size of the last raise faced, but only the amount you would need to call) is stored in: cash_hand_player_statistics.amt_r_raise_facing
The size of a bet is stored in: cash_hand_player_statistics.amt_r_bet_made
The size of the first and last raises are stored in: cash_hand_player_statistics.amt_r_raise_made cash_hand_player_statistics.amt_r_raise_made_2 (If you only raise once then the _2 value will be zero.)
Thanks a lot for your answer. Actually I still have difficulties. I created a stat which contains only amt_bet_r and it works perfectly, I can display it in hand reports. However I'm unable to create a stat with amt_r_bet_made because a popup comes "Invalid Value Expression". Why does it happen?
My expression was simply 'amt_r_bet_made', I wanted to see this info in the hand listings report. (Later I wanted to create some more stats with it but first of all I wanted to see if this stat is what I need indeed.) I tried to include the database table name, too, but it didn't help. The strange thing is that I have no problem to create a stat with 'amt_bet_r and', but once I try to do the same with 'amt_r_bet_made' I fail.
Did you put it in the Hand section? You'll want it in the Hand section to work like that. You will definitely want to refer to the table with the full cash_hand_player_statistics part in order for things to work properly.
However it doesn't give me the result I need. I need the result to be the amount of my very last CALL on the river, whatever happened before. (If I check/call, the result should be the amount of my call. If I bet 400, my opponent raise to 1000 and I call his raise, the result should be 600, since this is the amount of my last CALL. If I bet and my opponent calls, the result should be 0 since I didn't do any call.) Is there a column for that?