Limp/call vs Non-allin iso

[Naeco]

Hello,

I'm trying to make 2 separate stats for limp/call: one when hero has limped and faced an ISO shove and one when hero has limped and face a maximum 4bb iso.

I succesfully made the limp/call vs shove stat with this formula:

limp_call_shove
CODE: SELECT ALL
sum(if[tourney_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CC%' AND lookup_actions_f.action LIKE '', 1, 0])

limp_call_shove_opp
CODE: SELECT ALL
sum(if[tourney_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'C%' AND tourney_hand_player_statistics.enum_face_allin similar to 'P|p' , 1, 0])

However, I'm struggling with the limp/call vs NAI.

I tried this but It says The Statement is not valid SQL.

cnt_p_limp_fold_naiR
sum(if[tourney_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 4, 1, 0])

cnt_p_limp_faceraisenaiR
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 4, 1, 0])

Could someone tell me what I did wrong?

Thank you !

[Naeco]

OK I Just tried this and it seems to work

If someone can confirm that it looks okay:

cnt_p_limp_call_NAI
sum(if[tourney_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CC%'
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 2 AND 4, 1, 0])

cnt_p_limp_faceraise_NAI
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.flg_p_face_raise
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_blinds.amt_bb) / tourney_blinds.amt_bb) BETWEEN 2 AND 4, 1, 0])

[Flag_Hippo]

I tried this but It says The Statement is not valid SQL.

cnt_p_limp_fold_naiR
sum(if[tourney_hand_player_statistics.flg_p_limp AND lookup_actions_p.action = 'CF' AND tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 4, 1, 0])

cnt_p_limp_faceraisenaiR
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 4, 1, 0])

Could someone tell me what I did wrong?

That will not validate since there is a bracket mismatch as there isn't a corresponding (.

If someone can confirm that it looks okay:

cnt_p_limp_call_NAI
sum(if[tourney_hand_player_statistics.flg_p_limp AND lookup_actions_p.action LIKE 'CC%'
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 2 AND 4, 1, 0])

cnt_p_limp_faceraise_NAI
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.flg_p_face_raise
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_blinds.amt_bb) / tourney_blinds.amt_bb) BETWEEN 2 AND 4, 1, 0])

That looks fine.