BB vs SB Open Jam - Fold

[chrisbrandsborg]

Hi, Im trying to make the stat «BB vs SB Open Jam - Fold». I´ve used BB vs SB open - Fold and tried to modify it.

I duplicated cnt_p_bb_v_sb_fold, cnt_p_bb_v_sb_call and renamed them to cnt_p_bb_v_sb_jam_fold, cnt_p_bb_v_sb_jam_fold

BB vs SB Open Jam - Fold = ( cnt_p_bb_v_sb_jam_call / (cnt_p_bb_v_sb_jam_call+cnt_p_bb_v_sb_jam_folk) ) * 100

Description: Number of times player folded from BB when facing a SB open jam / (Number of times player folded from BB when facing a SB open jam + number of times player called from BB when facing a SB open ham)

Here´s what I have tried:

sum(if[tourney_hand_player_statistics.amt_p_raise_made >=
tourney_hand_player_statistics.amt_p_effective_stack and
tourney_hand_player_statistics.flg_p_first_raise and
tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 and
tourney_hand_player_statistics.flg_p_open_opp and
tourney_hand_player_statistics.position=8 and
tourney_hand_player_statistics.flg_blind_def_opp and
lookup_actions_p.action=‘F’, 1, 0])

Please tell me what is wrong here! I get a validation, but it doesnt work.

[Flag_Hippo]

If you want to build a stat for the BB you need to define the actions from the point of view of the player who the stat is for; however you're using expressions which are only true from the SB's perspective:

tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack
tourney_hand_player_statistics.flg_p_first_raise
tourney_hand_player_statistics.flg_p_open_opp