Hi,
took the build-in column cnt_f_face_xr_call and added the bold parts:
js2002_cnt_f_face_xr_call_fold_to_t_bet
sum ( if[
holdem_hand_player_statistics.flg_f_cbet AND
lookup_actions_f.action LIKE 'BC' AND
holdem_hand_player_statistics.flg_f_face_raise AND
((holdem_hand_player_detail.val_f_raise_aggressor_pos > holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_s)) AND
holdem_hand_player_detail.amt_t_bet_facing > 0 AND
lookup_actions_t.action LIKE 'F'
, 1, 0 ] )
for the denumerator I just remove the fold expression.
OK?