How to create a custom average 3bet size stat?

[Qwaserd]

I created a player column stat
val_p_total_3bet
sum(if[cash_hand_player_statistics.flg_p_3bet, cash_hand_player_statistics.amt_p_raise_made_2 / cash_limit.amt_bb, 0])
and a custom player stat
Avg 3Bet Size
if( cnt_p_3bet > 0, (val_p_total_3bet / cnt_p_3bet), 0 )

It gives an output but not the one I expected. Any idea what I am doing wrong?

I did similar for average rfi size
val_p_total_rfi
sum(if[cash_hand_player_statistics.flg_p_first_raise, cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb, 0])
Avg RFI Size
val_p_total_rfi / cnt_p_raise_first_in

This works as expected.

[Flag_Hippo]

I created a player column stat
val_p_total_3bet
sum(if[cash_hand_player_statistics.flg_p_3bet, cash_hand_player_statistics.amt_p_raise_made_2 / cash_limit.amt_bb, 0])
and a custom player stat
Avg 3Bet Size
if( cnt_p_3bet > 0, (val_p_total_3bet / cnt_p_3bet), 0 )

It gives an output but not the one I expected. Any idea what I am doing wrong?

You need to use cash_hand_player_statistics.amt_p_raise_made which is the size of the first preflop raise made by the player. cash_hand_player_statistics.amt_p_raise_made_2 is the size of the second raise made by the player which at minimum will be a 4bet.

I did similar for average rfi size
val_p_total_rfi
sum(if[cash_hand_player_statistics.flg_p_first_raise, cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb, 0])
Avg RFI Size
val_p_total_rfi / cnt_p_raise_first_in

This works as expected.

This isn't going to give you correct numbers. Based on the definition in PokerTracker 4 a 'Raise First In' means that the player opened the pot for a raise (i.e. no limpers) but you are summing the size of all 2bets regardless of whether it was first in or not. See the expression used for the cnt_p_raise_first_in column which also uses cash_hand_player_statistics.flg_p_open_opp.