Fold raise to a reraise?

[Spielerin]

Hey everyone,

I apologize in advance since I think this is a rather easy stat but I can't seem to get it to work right. I want to count how often someone raises and then folds to a reraise. I started with the limp/reraise column from the repository:
sum( if[tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.flg_p_fold, 1, 0] )

But I can't seem to modify it correctly to change from limp to raise. I replace the limp piece and come up with this:
sum( if[tourney_holdem_hand_player_statistics.cnt_p_raise AND tourney_holdem_hand_player_statistics.flg_p_fold, 1, 0] )

And it tells me that the code isn't valid. I'm not too familiar with writing these so go easy on me... what do I have wrong here??

[WhiteRider]

tourney_holdem_hand_player_statistics.cnt_p_raise is a "count" (hence the cnt_ prefix, so you need to check for it being > 0).
flg_ prefixed fields are flags, so are boolean (true/false) values, but cnt_ is numeric (i.e. you can only fold or not, but you can raise multiple times).

[Spielerin]

Ok, but I did try changing "cnt" to "flg" and that does not seem to work either?

[WhiteRider]

You're using the correct DB fields, but you need to check cnt_p_raise > 0, like this:

sum( if[tourney_holdem_hand_player_statistics.cnt_p_raise>0 AND tourney_holdem_hand_player_statistics.flg_p_fold, 1, 0] )