trying to build custom stats for calling 3 bets pre when oop/ip.
like for the oop version i think the val exp should be
(all the times we call AND are oop / all the opportunities to call AND are oop) * 100
and i did some copy and paste work and end up think that this sql should work-
------------------------------------------------------------------------------------------------------------------------------------------------------------------
{sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 3 and cash_hand_player_statistics.enum_p_3bet_action='C' AND cash_hand_player_statistics.flg_p_first_raise AND substring(cash_hand_summary.str_aggressors_p from 3 for 1)::int < cash_hand_player_statistics.position, 1, 0])
/
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 3 and cash_hand_player_statistics.flg_p_3bet_def_opp AND cash_hand_player_statistics.flg_p_first_raise AND substring(cash_hand_summary.str_aggressors_p from 3 for 1)::int < cash_hand_player_statistics.position, 1, 0])} * 100
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
but it doesn't and i honestly have ****** with this long enough to ask for help lol. idk if my approach in copy and paste is just wrong, or maybe just some minor syntax error somewhere. i did modify one thing from the first half of that sql. that snippet had come from the column named 'cnt_p_3bet_def_action_fold_when_open_raised_oop' and in that expression where is says .....>= 3 and cash hand player statistics.enum p 3bet action="F"..... i was pretty sure that that F was for fold, so i just changed it to C hoping it would interpret the new expression to get calls instead of folds lol. idk it might've worked. but i suck at computers and i really just want to stop beating my head against the wall on this. what am i missing?