PokerTracker

I'm having trouble creating this columns. Where is the mistake?

sum(if[cash_hand_player_statistics.cnt_t_donk > 0 AND cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand, 1, 0])

sum(if[cash_hand_player_statistics.cnt_t_donk > 0 AND cash_hand_player_statistics.flg_showdown, 1, 0])

Y also tried
sum(if[cash_hand_player_statistics.flg_t_raise > 0 AND cash_hand_player_statistics.flg_showdown, 1, 0])

Alex Gaita wrote:I'm having trouble creating this columns. Where is the mistake?

sum(if[cash_hand_player_statistics.cnt_t_donk > 0 AND cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand, 1, 0])

sum(if[cash_hand_player_statistics.cnt_t_donk > 0 AND cash_hand_player_statistics.flg_showdown, 1, 0])

Y also tried
sum(if[cash_hand_player_statistics.flg_t_raise > 0 AND cash_hand_player_statistics.flg_showdown, 1, 0])

cnt_t_donk & flg_t_raise do not exist in the PokerTracker 4 database schema. A turn donk bet is:

Code: Select all

cash_hand_player_statistics.flg_t_donk

Which would give you:

Code: Select all

sum(if[cash_hand_player_statistics.flg_t_donk AND cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand, 1, 0])

Code: Select all

sum(if[cash_hand_player_statistics.flg_t_donk AND cash_hand_player_statistics.flg_showdown, 1, 0])

works perfectly thanks!