fold to f c-bet betsize

[jaffa]

I want to make some fold to flop c-bet stats when facing certain betsizes for my popups. I tried to make the columns for a 3/4 pot betsize which look like this:

sum(if[cash_hand_player_statistics.enum_f_cbet_action='F' AND cash_hand_player_statistics.val_f_bet_facing_pct>'67' AND cash_hand_player_statistics.val_f_bet_facing_pct<'83', 1, 0])

sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp AND cash_hand_player_statistics.val_f_bet_facing_pct>'67' AND cash_hand_player_statistics.val_f_bet_facing_pct<'83', 1, 0])

They are both modified from the original fold to flop c-bet and faced flop c-bet stats. They don't work at the moment, although it says the expression is valid they are producing weird results, most of which are - but apparently mine is 100, which is obviously wrong

[kraada]

val_f_bet_facing_pct is a number in the database and putting single quotes around your comparisons turns them into strings, so what's likely happening is the comparison is ending up not working as you'd expect.

Take away the single quotes and things should work better.

Also your value is not what you want - the val_f_bet_facing_pct amount stores the percentage of the pot that you need to call. So if you have a bet of .75P where P is the pot the total pot size is now 1.75P and you have to call .75P - which is 42.8% of the pot. As it is now you're looking at fairly large overbets. Numbers like 40-45 or so should get you more of what you want to see.