open 4bet/fold help please

[js2002]

This is open 4bet preflop

((cnt_p_4bet - cnt_p_4bet_after_raising) / (cnt_p_4bet_opp - cnt_p_3bet_def_opp_when_open_raised)) * 100

I want to make the stat "open 4bet/fold"

what is the easiest way? can u build it 4 me?

[js2002]

my solution:

num:
sum(if[cash_hand_player_statistics.enum_p_4bet_action='F' AND cash_hand_player_statistics.enum_p_3bet_action='R' AND NOT(cash_hand_player_statistics.flg_p_first_raise), 1, 0])

denum:
sum(if[cash_hand_player_statistics.flg_p_4bet_def_opp AND cash_hand_player_statistics.enum_p_3bet_action='R' AND NOT(cash_hand_player_statistics.flg_p_first_raise), 1, 0])

correct?

[WhiteRider]

That looks fine, although it will count hands where the player limped and then 4Bet so you might want to rule out limps too for accuracy.

[js2002]

rar case but thx!