Hello!
I want to make a set of stats for BvB 2bet pot situations. To creata a Flop Cbet stat for SB I've made 2 columns:
cnt_f_cbet_bvb_2betpot = sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_p_open AND cash_hand_summary.str_aggressors_p = '89', 1, 0])
cnt_f_cbet_opp_bvb_2betpot = sum(if[cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_p_open AND cash_hand_summary.str_aggressors_p = '89', 1, 0])
And a positional stat (SB, OOP on Flop):
Cbet Flop Bvb 2betpot = (cnt_f_cbet_bvb_2betpot / cnt_f_cbet_opp_bvb_2betpot) * 100
I created a report to check that both columns work properly, but for some reason the stat doesn't work. What am I doing wrong?