by js2002 » Tue Sep 14, 2010 9:09 am
FINALLY:
sum(if[
holdem_hand_player_detail.val_r_bet_made_pct>0,
if[(100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct) * 1.1 * 2 + (100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct)<holdem_hand_summary.amt_pot AND (holdem_hand_player_detail.val_r_bet_made_pct > 110) AND holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand,1,0]
,0])
________________________________________
sum(if[
holdem_hand_player_detail.val_r_bet_made_pct>0,
if[(100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct) * 1.1 * 2 + (100 * holdem_hand_player_detail.amt_bet_r / holdem_hand_player_detail.val_r_bet_made_pct)<holdem_hand_summary.amt_pot AND (holdem_hand_player_detail.val_r_bet_made_pct > 110) AND holdem_hand_player_statistics.flg_showdown,1,0]
,0])
The orange Part checks:
"Is the final pot really > than the River Pot + 2x (the River Pot *1.1)"
[1.1 because rationally when we overbet 110% the pot has to be twice at least the overbet size + pot]
With this I catch the situations where I overbet a pot but the last caller only hast f.e. 50% potsize left. These cases now come to 0 in the sum I hope. My Report looks good, but can u please verify this stat?