column size cbet between 2 sizes

[Onani]

Hello, I am creating these columns, how could I make one that is, for example, size equal to or greater than 66% pot and less than 75% pot?

thank you so much

Minbet flop %
(cnt_minbet_flop / cnt_f_cbet) * 100

cnt_minbet_flop
sum(if[(cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.val_f_bet_made_pct < 40)
, 1, 0])

cnt_cbet_flop_mediopot
sum(if[(cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.val_f_bet_made_pct = 50)
, 1, 0])

cnt_cbet_flop_dostercios
sum(if[(cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.val_f_bet_made_pct = 66)
, 1, 0])

cnt_cbet_flop_trescuartos
sum(if[(cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.val_f_bet_made_pct = 75)
, 1, 0])

[Flag_Hippo]

Hello, I am creating these columns, how could I make one that is, for example, size equal to or greater than 66% pot and less than 75% pot?

That would be:

Code: Select all

cash_hand_player_statistics.val_f_bet_made_pct >= 66 and cash_hand_player_statistics.val_f_bet_made_pct < 75

[Onani]

I get this error, what am I doing wrong?


[img][img]https://i.ibb.co/vhRS8K9/Captura.png[/img][/img]

Sorry I had to click on the image, I didn't know how to do it so it appears in the message

[Flag_Hippo]

Have everything in lowercase and that should fix it:

Code: Select all

cash_hand_player_statistics.flg_f_cbet and cash_hand_player_statistics.val_f_bet_made_pct >= 79 and cash_hand_player_statistics.val_f_bet_made_pct < 90