cnt_pfr_opp based on player dealt

[4StarGen]

I got this code that should retrieve cnt_pfr_opp based on player dealt in the hand

Code: Select all

sum(if[ cash_hand_summary.cnt_players >= 5 AND (lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) )), 1, 0])

When I debug the stat it clearly shows a different number of instances greater than the number of hands played with a certain number of players

[Flag_Hippo]

After adding your custom column did you rebuild your custom database cache? If not please do so via 'Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild'.