I tried to create the stat "Fold to steal, facing non-allin" but It doesn't seem to work.
I duplicated the fold to steal formula and added "tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack" so that the first raise is only a non-allin raise.
Here is the formula I have created and used:
cnt_steal_def_action_fold_nai / cnt_steal_def_opp_nai
Where cnt_steal_def_action_fold_nai is the following:
sum(if[tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F'
AND tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack, 1, 0])
and cnt_steal_def_opp_nai is the following:
sum(if[tourney_hand_player_statistics.flg_blind_def_opp
AND tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack, 1, 0])
Have I done something wrong?