Fold to 4bet when 3bet (resteal)

[DreadX]

I'm trying to fix the stat in the general stats pop-up of Kraada's Advanced Hud.

The stat 'fold 3bet to 4bet' returns the percentage of the times a player 3bet in respect to the number of times this player 3betted (and not, 'was facing a 4bet').
To get this I've tried to create a column with this definition:

sum(if[holdem_hand_player_statistics.flg_p_4bet_def_opp and holdem_hand_player_statistics.flg_p_3bet
and
((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_statistics.position = 0)
or
(holdem_hand_summary.cnt_players > 4 and holdem_hand_player_statistics.position = 1)), 1, 0])

When I use this (btw this example is only for LP FR) it returns about 6400 opportunities (in 50k hands) and I happen to know I wasn't 4betted 6400 times in the 50k hANDS .

I used the same definition for the blinds and that stats works correct.
Blinds are identified by flg_bb or sb; the def for EP, MP and LP are defined by combo of nr of players and position. Could this (the combo) have something to do with the fact that the same opportunities are counted multiple times?

Would it be possible to let the user define a EP-, MP- or LP-flag in the database (as with the blinds) in PT4? Then I only have to define these positions once in stead of having to define each position in every column that uses table-position?

Thanks.

[WhiteRider]

Nothing leaps out at me as being wrong in that expression - please export your stat and attach it to a Support ticket so that we can check it out in more detail.
Thanks.

[kydechuk01]

Hi! Try this:

Stat: Fold Resteal to 4-Bet (SB)
Expression: (cnt_steal_3bet_fold_SB / cnt_steal_3bet_face_4b_SB) * 100

Columns:
cnt_steal_3bet_fold_SB

sum(if[holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])

cnt_steal_3bet_face_4b_SB
sum(if[holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

Big Blind F3to4 and Total F3to4 stats are like in this example.

[DreadX]

Thanx, both.

It appears that restarting the pc did the trick.