bet river after checks

[justforfun]

I try to make a stat which counts how many player bet the river after flop and turn have been checked no mather whether player is PFA or caller
My idea is something like this, but maybe im missing something as verification using filters failed

sum(if[cash_hand_player_statistics.flg_r_open AND (not cash_hand_player_statistics.flg_f_bet AND not cash_hand_player_statistics.flg_t_bet) AND cash_hand_player_statistics.amt_f_bet_facing = 0 AND cash_hand_player_statistics.amt_t_bet_facing = 0 AND lookup_actions_t.action = 'X' and lookup_actions_f.action = 'X', 1, 0])

sum(if[cash_hand_player_statistics.flg_r_open_opp AND (not cash_hand_player_statistics.flg_f_bet AND not cash_hand_player_statistics.flg_t_bet) AND cash_hand_player_statistics.amt_f_bet_facing = 0 AND cash_hand_player_statistics.amt_t_bet_facing = 0 AND lookup_actions_t.action = 'X' and lookup_actions_f.action = 'X', 1, 0])

[kraada]

Change cash_hand_player_statistics.flg_r_open to cash_hand_player_statistics.flg_r_bet and you should be fine.

This could be done more simply though as you don't need to specify that you didn't bet or face a bet when the actions string is exactly 'X' - when you test via equals it's testing the whole string and XF will not match = 'X'. So this would work just as well:

sum(if[cash_hand_player_statistics.flg_r_open_opp AND lookup_actions_t.action = 'X' and lookup_actions_f.action = 'X', 1, 0])

and the same with flg_r_bet as your actions column.