Call F C/R Fold to Turn Bet

[erdnase17]

I am trying to define a custom stat to count how often a player calls a flop check raise and then folds to a turn bet (heads up games).
It is based on the column:
sum(if[lookup_positions.flg_sb AND lookup_actions_f.action like 'BC' AND lookup_actions_t.action like 'F', 1, 0 ])

and the opportunities column:
sum(if[lookup_positions.flg_sb AND lookup_actions_f.action like 'BC' and tourney_hand_player_statistics.flg_t_cbet_def_opp, 1, 0 ])

This stat does not show any value in the HUD, however it will filter hands correctly in the Holdem Range Visualizer.

What is wrong with the stat definition?

Thanks.

[kraada]

I presume you meant to post this in the PT4 forums given the columns? Those look like PT4 definitions not PT3.

Regardless - the issue is the cbet_def_opp portion in your opportunities. It's not considered a turn cbet just because they raised the flop - it's only a turn cbet if it continues from a flop cbet which continues from preflop action.

So in this case use tourney_hand_player_statistics.amt_t_bet_facing > 0 to indicate that you faced some turn bet.