One of my custom stats is not working anymore and I can't figure out why. I want to count the calls from the Big Blind when SB has made a PF open raise to 2 to 3bb.
Here is the value expression and the columns:
(cnt_p_mr_call / cnt_p_mr_call_opp) * 100
cnt_p_mr_call: sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) BETWEEN 1 AND 2 AND lookup_actions_p.action LIKE 'C' and tourney_hand_summary.str_actors_p LIKE '9%', 1, 0])
cnt_p_mr_call_opp: sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) BETWEEN 1 AND 2 and tourney_hand_summary.str_actors_p LIKE '9%', 1, 0])
I see every players with 0% and when checking the number of occurrences I see that there is the "cnt_p_mr_call_opp" column seems to work fine but the "call" column doesn't seem to work.
Btw I didn't specify we were in the BB because I change the position directly with the HUD profile editor.