culumns

[raph156]

Hi,
i want when id= and bb and make an action pre flop (so villain didnt fold in HU).
when bet pre flop 11 25 and bb and id=
There must be something wrong cause my stats dont work.


sum( if[ ((holdem_hand_player_statistics.id_holecard = 1 OR holdem_hand_player_statistics.id_holecard = 26 OR holdem_hand_player_statistics.id_holecard = 49 OR holdem_hand_player_statistics.id_holecard = 70 OR holdem_hand_player_statistics.id_holecard = 89 OR holdem_hand_player_statistics.id_holecard = 106 OR holdem_hand_player_statistics.id_holecard = 121 OR holdem_hand_player_statistics.id_holecard = 2) AND (holdem_hand_player_statistics.flg_blind_b) AND (( substring(lookup_actions_p.action from 1 for 1)='X') OR (substring(lookup_actions_p.action from 1 for 1)='R') OR (substring(lookup_actions_p.action from 1 for 1)='F') OR (substring(lookup_actions_p.action from 1 for 1)='C'))) ,1, 0])

sum( if[((holdem_hand_player_detail.amt_bet_p BETWEEN ( 11*holdem_limit.amt_bb) AND ( 25*holdem_limit.amt_bb)) AND (holdem_hand_player_statistics.flg_blind_b) AND (holdem_hand_player_statistics.id_holecard = 1 OR holdem_hand_player_statistics.id_holecard = 26 OR holdem_hand_player_statistics.id_holecard = 49 OR holdem_hand_player_statistics.id_holecard = 70 OR holdem_hand_player_statistics.id_holecard = 89 OR holdem_hand_player_statistics.id_holecard = 106 OR holdem_hand_player_statistics.id_holecard = 121 OR holdem_hand_player_statistics.id_holecard = 2)) ,1 ,0])

Thanks for help

[raph156]

thise one dont work too:
sum( if[(holdem_hand_player_detail.amt_bet_p BETWEEN ( 11*holdem_limit.amt_bb) AND ( 25*holdem_limit.amt_bb) AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_won_hand ) ,1 ,0])

sum( if[(holdem_hand_player_detail.amt_bet_p BETWEEN ( 11*holdem_limit.amt_bb) AND ( 25*holdem_limit.amt_bb) AND holdem_hand_player_statistics.flg_blind_b ) ,1 ,0])

i tryed with more () but no change
sum( if[((holdem_hand_player_detail.amt_bet_p BETWEEN ( 11*holdem_limit.amt_bb) AND ( 25*holdem_limit.amt_bb)) AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_won_hand ) ,1 ,0])
Thanks for help

[kraada]

All 5 of those validate for me - what part of them is not working for you?

[raph156]

Its valid, but when i want the stas on summary, there is a red message error

[kraada]

Please restart PT3 with the Logging Enabled link, reproduce and report this problem and we will investigate further for you.