Npyu_system wrote:Thank you so much !
It's crystal clear now !
I was trying to integrate the expression you gave me in the expression of the stat itself, not in the expression of each term of the stat.
I get it now.
I just did vpip for 0-10bb and it seems to be working !
Now I just have to rinse & repeat for other stack sizes and other stats.
Thank you !
How did you do for opp ? for pfr or vpip?
sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (tourney_hand_player_statistics.amt_before > (tourney_blinds.amt_bb + tourney_hand_player_statistics.amt_ante)) AND (tourney_hand_player_statistics.amt_p_raise_facing < (tourney_hand_player_statistics.amt_before - (tourney_hand_player_statistics.amt_blind + tourney_hand_player_statistics.amt_ante))) AND (tourney_hand_player_statistics.flg_p_open_opp OR tourney_hand_player_statistics.cnt_p_face_limpers > 0 OR tourney_hand_player_statistics.flg_p_3bet_opp OR tourney_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])
what should i add? please or anywaty thanks anyway lol