Hi, I'm sure this type of post is very common, but I can't seem to understand what I'm doing wrong... Maybe someone could help me?
I tried creating a custom statistic that should count the % of times BB folds vs a SB open between 2 and 2.5bb specifically. I tried it in game and it counts folds vs bigger bets too.
The statistic is: ( cnt_p_bb_v_sb_fold / (cnt_p_bb_v_sb_fold+cnt_p_bb_v_sb_call_NAI+cnt_p_bb_v_sb_3bet) ) * 100
The collums are default to PT4, except for
cnt_p_bb_v_sb_call_NAI
sum(if[tourney_hand_player_statistics.position=8 AND tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 2 AND 2.5 AND tourney_hand_player_statistics.val_p_raise_aggressor_pos=9, 1, 0])
If anyone could give me some clarity, it'd be very appreciated. Thanks in advance!