Custom statistic not working as intended

[Joop59]

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!

[Flag_Hippo]

This custom column you have is only for the calls and since you are still using default columns for the folds (and 3bets) then they will be counting hands versus all raise sizes.

[Joop59]

I see! thank you very much.

[Joop59]

Okay, so I made a few changes.

I made a custom collumn for the folds:

cnt_p_bb_v_sb_fold_nai
sum(if[tourney_hand_player_statistics.position=8 AND tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='F' 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])

So, now the statistic goes:
( cnt_p_bb_v_sb_fold_nai / (cnt_p_bb_v_sb_fold_nai+cnt_p_bb_v_sb_call_NAI+cnt_p_bb_v_sb_call+cnt_p_bb_v_sb_3bet) ) * 100

Do you think it will work as intended now? Thanks again!

Edit: actually, i got something wrong and edited the post.

[Flag_Hippo]

So, now the statistic goes:
( cnt_p_bb_v_sb_fold_nai / (cnt_p_bb_v_sb_fold_nai+cnt_p_bb_v_sb_call_NAI+cnt_p_bb_v_sb_call+cnt_p_bb_v_sb_3bet) ) * 100

Do you think it will work as intended now? Thanks again!

Edit: actually, i got something wrong and edited the post.

That's still not going to calculate correctly for two reasons:

1. For the calls you are using the custom column and the default column.

2. You are still using the default column for the 3bets.

[Joop59]

Ah, I see.

Thanks a lot! I'm very new to making custom statiscs. I managed to fix it now