custom stat advice please

[js2002]

c/f as PFA in 3bet pot ALIAS
Fold to Float in 3bet pot

I took fold to float and added the 3betpot check ((cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet))
Now the stat is empty.
I dont know why, first i thought
because not(cash_hand_player_statistics.flg_p_face_raise) and 3bet or 4bet results into zero.
Im not sure now.
does the original fold to float stat filter out 3bet pots? I guess so, because I just added "AND (3bet or 4bet)"

Can somebody tell me how to fix that?

sum(if[ not(cash_hand_player_statistics.flg_p_face_raise) AND lookup_actions_p.action LIKE '%R' and cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XF' AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])
___________
sum(if[ not(cash_hand_player_statistics.flg_p_face_raise) AND lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.flg_f_check AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])



EDIT:
@PT most stats are apllied for all pot sizes (2betpot,3betpot...)
Why does PT get inconsistent here and makes "Fold to Float" to single raised pots only?

[WhiteRider]

"Floating" is calling a bet and then betting in position when the aggressor from the previous street checks.
If you raise then you can't "float bet" the next street. Preflop we're not looking at a "bet" but we only count the 2Bet - if you raise preflop then you can't "float bet" the flop, just as if you raise the flop you can't float bet the turn.

[js2002]

man, u misunderstand.
Its FOLD to float (in 3betpot)
and the question is: why u filter out 3bet+pots

[WhiteRider]

The same argument applies - if you can only make a float bet in a pot where there was a raise which was called, then that is the only type of hand where you can fold to a float bet too.

Postflop, if there is a bet and a raise, and you call, then it isn't possible to make a float bet on the next street even if the action is checked to you.
Therefore, if there is a raise and a reraise preflop there is no float bet possibility on the flop.

If you want to make a version of the stat which doesn't have that restriction then you can remove the tests for no 3Bet or higher preflop.

[js2002]

We can't comunicate.
I wait for kraada, he will understand me.

If u want to understand: READ my Texts without beeing drunk^^

[js2002]

#2nd
wait: i descrip a line:

Hero 4bets preflop, the 3bettor Villian calls the 4bet.

U see the Problem?
Hero faces a preflop raise and so the fold to float stat filters out this pot. And I ask why!
Because PT defines stats for all potsizes but here filters out these pots.


(ps 3bet pots where Hero/Player is PFA also result to zero. WHY? bug?)

TESTCASE:
cash_hand_player_statistics.flg_p_3bet AND (cash_hand_player_statistics.flg_p_face_raise)

I get this hand for JJ as player:

PokerStars Game #66086648900: Hold'em No Limit ($0.02/$0.05 USD) - 2011/08/16 14:11:11 CET [2011/08/16 8:11:11 ET]
Table 'Bernhard' 6-max Seat #4 is the button
Seat 1: ApxuTecTop ($5.14 in chips)
Seat 2: sinee1 ($6.83 in chips)
Seat 3: cromir ($4.06 in chips)
Seat 4: A4O 24 ($7.14 in chips)
Seat 5: littleshoe91 ($4.79 in chips)
Seat 6: js2002 ($5 in chips)
littleshoe91: posts small blind $0.02
js2002: posts big blind $0.05
*** HOLE CARDS ***
Dealt to js2002 [Jh Js]
ApxuTecTop: folds
sinee1: folds
cromir: folds
A4O 24: raises $0.10 to $0.15
littleshoe91: folds
js2002: raises $0.33 to $0.48
A4O 24: calls $0.33
*** FLOP *** [Jc 9c 7h]
js2002: bets $0.58
A4O 24: raises $1.05 to $1.63
js2002: raises $2.89 to $4.52 and is all-in
A4O 24: calls $2.89
*** TURN *** [Jc 9c 7h] [3s]
*** RIVER *** [Jc 9c 7h 3s] [As]
*** SHOW DOWN ***
js2002: shows [Jh Js] (three of a kind, Jacks)
A4O 24: mucks hand
js2002 collected $9.53 from pot
*** SUMMARY ***
Total pot $10.02 | Rake $0.49
Board [Jc 9c 7h 3s As]
Seat 1: ApxuTecTop folded before Flop (didn't bet)
Seat 2: sinee1 folded before Flop (didn't bet)
Seat 3: cromir folded before Flop (didn't bet)
Seat 4: A4O 24 (button) mucked [Jd 9d]
Seat 5: littleshoe91 (small blind) folded before Flop
Seat 6: js2002 (big blind) showed [Jh Js] and won ($9.53) with three of a kind, Jacks

so this
not(cash_hand_player_statistics.flg_p_face_raise) filters out all pots but singleraised ones. = idiotic 4 the fold to float stat