Float Flop

[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

[Flag_Hippo]

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'

I tried a few things but didn't work.

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