Help needed: RFI Fold depending on Stack and Raise Size

[preparac]

Hi people
I built RFI Fold to 3Bet stats depending on stack sizes OR raise sizes. But when I try to combine them, I only get some weird results...

So why

nominator
sum(if[tourney_holdem_hand_player_statistics.enum_p_3bet_action='F' and tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND (tourney_holdem_hand_player_detail.amt_bet_p / tourney_holdem_blinds.amt_bb = 2) AND (tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb > 40), 1, 0])

over

denominator
sum(if[tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp AND tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND (tourney_holdem_hand_player_detail.amt_bet_p / tourney_holdem_blinds.amt_bb = 2) AND (tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb > 40), 1, 0])

doesn't give me reasonable results (but allways n/A or 100% for instance)?? Probably I overlook somethin trivial?? Obviously tourney_holdem_hand_player_detail.amt_bet_p seems to be the problem. It doesn't measure any more the size of the initial RFI-bet, as soon there is a 3bet after ...?
Any help much appreciated ...

[kraada]

You're right about the expression that's the problem.

tourney_holdem_hand_player_detail.amt_bet_p / tourney_holdem_blinds.amt_bb = 2

is going to be true only when the amount a player bet preflop is exactly twice the size of the big blind. So you're only getting cases when someone minraises and gets 3bet (and folds), and since that's going to come about fairly rarely (even in a tournament), you're probably getting an extremely small sample for that reason.

[preparac]

No thats not the point, anyway I have a huge Database with over 2 Mio hands. But look also with the expression for standardraises

sum(if[tourney_holdem_hand_player_statistics.enum_p_3bet_action='F' and tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND
(tourney_holdem_hand_player_detail.amt_bet_p / tourney_holdem_blinds.amt_bb <= 3) AND (tourney_holdem_hand_player_detail.amt_bet_p / tourney_holdem_blinds.amt_bb > 2.5) AND
(tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb > 40), 1, 0])
over
sum(if[tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp and tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND
(tourney_holdem_hand_player_detail.amt_bet_p / tourney_holdem_blinds.amt_bb <= 3) AND (tourney_holdem_hand_player_detail.amt_bet_p / tourney_holdem_blinds.amt_bb > 2.5) AND
(tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb > 40), 1, 0])

I get theese weird 100% results ... (( (2/2), (1/1), lots of N/A, but NO (0/1) ))... and only with the expression for big raises

sum(if[tourney_holdem_hand_player_statistics.enum_p_3bet_action='F' and tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND (tourney_holdem_hand_player_detail.amt_bet_p / tourney_holdem_blinds.amt_bb > 3) AND (tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb > 40), 1, 0])
over
sum(if[tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp and tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND(tourney_holdem_hand_player_detail.amt_bet_p / tourney_holdem_blinds.amt_bb > 3) AND (tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb > 40), 1, 0])

there I have the oposite anomalie, because this gives me lots of results like (3/250) , (2/341) or so .... So I dont get it ... you can help me to figure it out what goes wrong?

[preparac]

To be more exact:

For some 12000 of my own hands I get the following ressults for RFI fold to 3Bet with a stack > 40 BB :

Small RFI <= 2.5 BB = fold 18 of 18
Standard RFI 2.5-3 BB = fold 16 of 16
Big RFI > 3BB = fold 3 of 56

which obv. makes no sense ...

[kraada]

I don't have enough tournament stats to check the tournament side but running queries against my database personally everything looks like it should be right. I'm heading out for the day in a minute; could you attach one of the stats that isn't working right to a support ticket? We'll investigate from there.

[preparac]

Ok, I did
thanx for help