What is wrong with this stat?

[shahrad]

sum(if[omaha_hand_player_statistics.flg_p_face_raise AND NOT(omaha_hand_player_statistics.flg_p_3bet OR omaha_hand_player_statistics.flg_p_4bet) and NOT(omaha_hand_player_statistics.flg_p_4bet_opp) and lookup_actions_p.action LIKE 'C' and omaha_hand_player_statistics.flg_t_float and omaha_hand_summary.cnt_players_f=2 , 1, 0])

It doesn't recognize the cases when someone did limp and faced a raise from the blinds and did float turn. In all other cases it works.

I did try it also with omaha_hand_player_statistics.cnt_p_call = 1 (instead of lookup_actions_p.action LIKE 'C' ) and without omaha_hand_player_statistics.flg_p_4bet_opp. Same problem.

[kraada]

Can you paste a hand that's coming through for that stat that shouldn't? That would make it a lot easier to figure out what's going wrong.

[shahrad]

It doesn't count this hand as a float:
Full Tilt Poker Game #24849176109: Table Tuft (6 max) - $0.25/$0.50 - Pot Limit Omaha Hi - 04:15:01 ET - 2010/10/20
Seat 1: kicsako ($50)
Seat 2: TnT1976 ($27.45)
Seat 3: The Aqualung ($50)
Seat 4: jiklaawin ($94.30)
Seat 5: Alastor85 ($32.20)
Seat 6: mattard73 ($64.35)
mattard73 posts the small blind of $0.25
kicsako posts the big blind of $0.50
The button is in seat #5
*** HOLE CARDS ***
TnT1976 calls $0.50
The Aqualung folds
jiklaawin folds
Alastor85 folds
mattard73 calls $0.25
kicsako has 15 seconds left to act
kicsako raises to $2
TnT1976 calls $1.50
mattard73 folds
*** FLOP *** [As 9c Ah]
kicsako has 15 seconds left to act
kicsako bets $4.50
TnT1976 calls $4.50
*** TURN *** [As 9c Ah] [7h]
kicsako checks
TnT1976 bets $6.75
kicsako folds
kicsako adds $6.50
Uncalled bet of $6.75 returned to TnT1976
TnT1976 mucks
TnT1976 wins the pot ($12.85)
*** SUMMARY ***
Total pot $13.50 | Rake $0.65
Board: [As 9c Ah 7h]
Seat 1: kicsako (big blind) folded on the Turn
Seat 2: TnT1976 collected ($12.85), mucked
Seat 3: The Aqualung didn't bet (folded)
Seat 4: jiklaawin didn't bet (folded)
Seat 5: Alastor85 (button) didn't bet (folded)
Seat 6: mattard73 (small blind) folded before the Flop

[WhiteRider]

lookup_actions_p.action LIKE 'C' is equivalent to lookup_actions_p.action = 'C'. That will never be true when the player faces a raise.
You need to use:
lookup_actions_p.action LIKE 'C%'
..which checks for a call and then any other (zero or more) actions.