by Darvini » Thu Feb 03, 2011 3:39 pm
All I need is a check in my column whether the table is a cap table or not. If I have that I can just add amt_bet_p to check if the player has capped or not.
At the moment my pf3BAI colums is:
sum(if[ holdem_hand_player_statistics.flg_p_3bet and not(holdem_hand_player_statistics.flg_blind_def_opp) AND holdem_hand_player_statistics.enum_allin = 'P' AND (lookup_actions_p.action = 'R' or lookup_actions_p.action = 'CR' ) and (holdem_hand_player_detail.amt_before / holdem_limit.amt_bb) <= 30, 1 , 0 ] )
So it would become:
sum(if[ holdem_hand_player_statistics.flg_p_3bet and not(holdem_hand_player_statistics.flg_blind_def_opp) AND (lookup_actions_p.action = 'R' or lookup_actions_p.action = 'CR' ) AND (((holdem_hand_player_detail.amt_bet_p / holdem_limit.amt_bb) = 20 AND CAPTABLE) or (holdem_hand_player_statistics.enum_allin = 'P' AND (holdem_hand_player_detail.amt_before / holdem_limit.amt_bb) <= 30)), 1 , 0 ] )