Average bet amount in probe turn

[buzzleclair21]

Hello, I try to create the the average bet amount in the line "probe turn" but I've error. Please help me


sum(if[cash_hand_player_statistics.flg_t_bet, cash_hand_player_statistics.val_t_bet_made_pct, 0 AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action NOT LIKE '%R' AND cash_hand_player_statistics.flg_p_face_raise AND ((cash_hand_summary.cnt_players >= 3 and cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 and cash_hand_player_statistics.flg_blind_b)), 1, 0])

Thanks a lot

[Flag_Hippo]

The column needs to be in this format:

Code: Select all

sum(if[expression, then, else])

For example:

Code: Select all

sum(if[cash_hand_player_statistics.flg_t_bet AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action NOT LIKE '%R' AND cash_hand_player_statistics.flg_p_face_raise AND ((cash_hand_summary.cnt_players >= 3 and cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 and cash_hand_player_statistics.flg_blind_b)), cash_hand_player_statistics.val_t_bet_made_pct, 0])