Custom Stats xxB

[Alex Gaita]

I'm struggling, the validation is correct, but the stat didn't count any cases

(cnt_r_xxB_cbet / cnt_r_xxB_cbet_opp) * 100

cnt_r_xxB_cbet
sum(if[char_length(cash_hand_summary.str_aggressors_p) = 2 and cash_hand_player_statistics.flg_r_bet AND
(cash_hand_player_statistics.amt_r_bet_made > 0)AND
cash_hand_player_statistics.flg_t_cbet_opp AND lookup_actions_t.action='X' AND
cash_hand_player_statistics.flg_f_cbet_opp AND lookup_actions_f.action='X', 1, 0])

cnt_r_xxB_cbet_opp
sum(if[char_length(cash_hand_summary.str_aggressors_p) = 2 and cash_hand_player_statistics.flg_r_open_opp AND
cash_hand_player_statistics.flg_t_cbet_opp AND lookup_actions_t.action='X' AND
cash_hand_player_statistics.flg_f_cbet_opp AND lookup_actions_f.action='X', 1, 0])

[Flag_Hippo]

You should remove cash_hand_player_statistics.flg_t_cbet_opp since it is not going to be true if the player did not CBet the flop.

[Alex Gaita]

like this will be fine?

cnt_r_xxB_cbet_opp
sum(if[char_length(cash_hand_summary.str_aggressors_p) = 2 and cash_hand_player_statistics.flg_r_open_opp AND lookup_actions_t.action='X' AND
cash_hand_player_statistics.flg_f_cbet_opp AND lookup_actions_f.action='X', 1, 0])

cnt_r_xxB_cbet
sum(if[char_length(cash_hand_summary.str_aggressors_p) = 2 and cash_hand_player_statistics.flg_r_bet AND
(cash_hand_player_statistics.amt_r_bet_made > 0)AND lookup_actions_t.action='X' AND
cash_hand_player_statistics.flg_f_cbet_opp AND lookup_actions_f.action='X', 1, 0])

[Flag_Hippo]

Yes that's fine.