Saw flop as preflop aggressor stat

[pkrlvr]

I'm trying to create a stat to determine how many times someone saw a flop as the preflop aggressor. I thought something like this might work but it's returning a count of 0, any ideas?

sum(if[(holdem_hand_player_detail.val_p_raise_aggressor_pos =
holdem_hand_player_statistics.position) AND
holdem_hand_player_statistics.flg_f_saw , 1 , 0])

[WhiteRider]

I'm not sure there's a simple solution to this one at the moment..

holdem_hand_player_detail.val_p_raise_aggressor_pos is a little complicated when you are involved in the aggression.
I think that if you are the only aggressor, then the value will be -1, and if someone else is involved then it's value is their position. I can't remember exactly what happens here, but I think if there is a raise and you re-raise, or if you raise and get re-raised, the value will still be the opponent's position in both cases.
I feel that this needs to be made more intuitive, and I've made some suggestions, but I think it will be a while before any changes are made.

You may be able to create what you want with a combination of flop continuation bet stats instead, though.
For instance, I *think* this might work..
holdem_hand_player_statistics.flg_f_cbet_opp OR NOT holdem_hand_player_statistics.flg_f_cbet_def_opp
..so you either had chance to make a c-bet on the flop (which means you were the PF aggressor) OR you were not facing a c-bet (if you're facing a bet that isn't a c-bet, then it's not from the PF aggressor).
This might not count cases when you face a bet and raise from 2 opponents when you were the PF-agg, though..
Also, if there are 3 to the flop, there might be a bet from the 3rd player who is not the PF-agg, but that doesn't mean you are either.

I'll re-test the PF-A stat later if I have some time.