Bet T after Check Flop

[philip77]

Hi,

I need some help to build a couple of similar statistics.
I want to calculate the percent of time a player Bet the Turn (the River), after there were no betting on the Flop (the Turn).
I want that the stats count only his real betting opportunity, ie if he is in position on Turn, and someone else bet the Turn before him, after the check-check Flop, that won't be include in the stats, because he did not have an opportunity to bet (only to raise, call or fold).

Thanks.

[kraada]

This is for the turn:

cnt_t_bet_after_f_checkthrough: sum(if[lookup_actions_f.action = 'X' and holdem_hand_player_statistics.flg_t_bet, 1, 0])

cnt_t_open_opp_after_f_checkthrough: sum(if[lookup_actions_f.action = 'X' and holdem_hand_player_statistics.flg_t_open_opp, 1, 0])

For the river, change references to the turn to the river and references to the flop to the turn.

[philip77]

Thanks,
But I have a problem with the opp. formula, I got an "The statement is not valid SQL".

[kraada]

Ah try this then:
sum(if[lookup_actions_f.action = 'X' and holdem_hand_player_detail.flg_t_open_opp, 1, 0])