It is defined as:
(cnt_p_vpip_facing_minraise_7_13 / cnt_p_call_opp_7_13) * 100
where cnt_p_call_opp_7_13 is defined as:
- Code: Select all
sum(if[lookup_positions.flg_bb AND tourney_hand_player_statistics.amt_p_2bet_facing > 0 AND (tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb) <= 1.25 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 0 and 7, 13, 0])
and cnt_p_vpip_facing_minraise_7_13 is defined as:
- Code: Select all
sum(if[(lookup_actions_p.action = 'C' OR tourney_hand_player_statistics.flg_p_3bet) AND lookup_positions.flg_bb AND tourney_hand_player_statistics.amt_p_2bet_facing > 0 AND tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb <= 1.25 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 7 AND 13, 1, 0])
This statistic seems to work fine but when I use it in conjunction with a quick filter like
- Code: Select all
(Table Size 2 Max Tournaments) AND (NOT (Tournament Speed Super)) AND (NOT (Tournament Speed Hyper))
it will show incorrect values (in my case it shows a value above 100%).
I can't find anything wrong in the definition. What am I missing?
Thanks.