Page 1 of 1

Float Flop

PostPosted: Fri Mar 17, 2023 5:58 pm
by xpastorcitox
Hi, I want to build a Float Flop stat for SRP specifically BB vs SB.

sum(if[ (lookup_actions_p.action = 'C' OR lookup_actions_p.action = 'CC') AND cash_hand_player_statistics.flg_p_face_raise AND cash_hand_player_statistics.flg_f_bet AND char_length(cash_hand_summary.str_aggressors_p) = 2 AND ((cash_hand_summary.cnt_players > 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_f_has_position)), 1, 0])


Can you help me with what should I change in the variable? I tried a few things but didn't work. Thanks

Re: Float Flop

PostPosted: Sat Mar 18, 2023 11:51 am
by Flag_Hippo
xpastorcitox wrote:Can you help me with what should I change in the variable?

Add this:

Code: Select all
cash_hand_summary.str_aggressors_p LIKE '89' and cash_hand_summary.str_actors_p LIKE '98'

xpastorcitox wrote:I tried a few things but didn't work.

If you include what you tried then we can give advice on that.