culumns

[raph156]

i would like, number of time a player faced a bet >2bb and <3 bb and call or raise.
i tryed
sum(if[holdem_hand_player_detail.amt_f_bet_facing > ( 2 * holdem_limit.amt_bb) and holdem_hand_player_detail.amt_f_bet_facing < ( 3 * holdem_limit.amt_bb) and holdem_hand_player_statistics.cnt_call or holdem_hand_player_statistics.cnt_raise, 1, 0])
or
sum(if[holdem_hand_player_detail.amt_f_bet_facing > ( 2 * holdem_limit.amt_bb) and holdem_hand_player_detail.amt_f_bet_facing < ( 3 * holdem_limit.amt_bb) and holdem_hand_player_statistics.cnt_fold, 1, 0])
How can i validate my column?
Tx for help

[kraada]

cnt_call and cnt_fold are not valied fields. You need to use valid database fields - and for cnt_ fields they are counts. So you might want cnt_p_call > 0 (you made at least 1 preflop call), or cnt_p_call > 1 (you made at least two preflop calls) etc.

For the full list of valid fields please see the database schema on our documentation page.