Raise over limper average size

[socito]

Hi, I'm trying to make this stat like this:

(amt_p_iso_total_bb / cnt_p_raise_first_in)


amt_p_iso_total_bb
sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp AND cash_hand_player_statistics.cnt_p_face_limpers=1, (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb), 0])

cnt_p_raise_first_in
sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp, 1, 0])

Not sure what am I doing wrong, but doesn't show any

Pd: I made Raise First average size and it's working ok
Help please

[Flag_Hippo]

amt_p_iso_total_bb
sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp AND cash_hand_player_statistics.cnt_p_face_limpers=1, (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb), 0])

It's not an open opportunity when there is a limper.

cnt_p_raise_first_in
sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp, 1, 0])

You can't use cnt_p_raise_first_in for this. You need a custom column that specifies the limper faced:

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.cnt_p_face_limpers = 1, 1, 0])

[socito]

I fixed, thanks!