Stat for amount of call on the river

[WhiteRider]

"cash_hand_player_statistics.amt_r_race_facing" is the amount you need to call when facing a raise, not the absolute size of the raise.

[sawwee]

"cash_hand_player_statistics.amt_r_race_facing" is the amount you need to call when facing a raise, not the absolute size of the raise.

Yes, but it doesn't consider if you are allin, so it gives incorrect result! Once I have $300 in my stack and I'm faced a $500 raise I cannot call $500 but only $300. 'cash_hand_player_statistics.amt_r_race_facing' still gives $500 as a result.

[kraada]

That would not be intended behavior - it should give 300 in that instance. Please attach the hand history for a hand that does that to a support ticket and we'll look into this further.

And just to clarify - when your actions are LIKE '%C' that means your last action must have been call so you cannot have folded.

[sawwee]

That would not be intended behavior - it should give 300 in that instance. Please attach the hand history for a hand that does that to a support ticket and we'll look into this further.

And just to clarify - when your actions are LIKE '%C' that means your last action must have been call so you cannot have folded.

OK, I opened a support ticket and attached hand history.

About fold:
You gave me this stat: sum(if[lookup_actions_f.action LIKE '%C' and cash_hand_player_statistics.flg_r_face_raise, cash_hand_player_statistics.amt_r_race_facing, cash_hand_player_statistics.amt_r_bet_facing])
This stat will give amt_r_race_facing as a result if the conditions happens (it means it happens when you call AND facing a raise), and will give amt_r_bet_facing as a result if the conditions doesn't happen. (it means amt_r_bet_facing will be the result if you don't call and / or don't face a raise.) When you fold, the condition doesn't happen, but the result should be 0, it shouldn't be amt_r_bet_facing, I guess. Isn't it like that? (However I already created my version based on yours, changing the condition and the "then" line. (Sorry, i don't know how to explain that in English.) It seems to be work now, except the facing allin problem.)
(moreover I corrected 'race' to 'raise' )

[kraada]

You must face a bet or a raise if you made a call. Since we already know that your action string ended with a call, you must have faced some bet or raise. Then we just add up whichever one it is you actually faced - if you faced a raise, we add the raise amount. If you didn't face a raise, then you must have faced a bet, since we know you called something, and we add that amount.

[sawwee]

Since we already know that your action string ended with a call,...

The problem is that in your stat we don't know that my action ended with a call, because it is inside of the "IF" part of the stat.
If my opponent bets or raise and I fold, your stat still will give the amount of my opponent's bet or raise as the result, even though I didn't call. In this case the reasult should be '0' instead of the amount of the faced bet or raise, because I folded, I didn't make any call.
I tested your stat and it gives the amount of the faced bet of raise as a result even if I fold or check/fold.

[sawwee]

(and instead of lookup_actions_f.action it should be lookup_actions_r.action, I suppose, but it doesn't change the the main quitestion.)

[kraada]

Ah, I see what you're saying now. You're right, it should read:

sum(if[lookup_actions_r.action LIKE '%C', if[cash_hand_player_statistics.flg_r_face_raise, cash_hand_player_statistics.amt_r_race_facing, cash_hand_player_statistics.amt_r_bet_facing], 0])

[sawwee]

Ah, I see what you're saying now. You're right, it should read:

sum(if[lookup_actions_r.action LIKE '%C', if[cash_hand_player_statistics.flg_r_face_raise, cash_hand_player_statistics.amt_r_race_facing, cash_hand_player_statistics.amt_r_bet_facing], 0])

Yes, exactly!
Thanks a lot!