Hi, i'm trying to make a 4bet custom stat but the effective stack is only related to the stat player. I want to know the effective stack from the player that is doing the 3bet
I guess i have to make a subquery but can't figure it out, any ideas?
sum(if[cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_4bet and (select 3bet.amt_p_effective_stack from cash_hand_player_statistics as 3bet
where (cash_hand_player_statistics.id_hand = 3bet.id_hand
and 3bet.flg_p_3bet)
/ cash_limit.amt_bb) <= 25, 1, 0])