Notetracker ideas

[GORANBAXY]

Ok so you need to make two custom columns here, with the definitions as follows:

cnt_p_3bet_fold_to_cold_4b: sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 4 and cash_hand_player_statistics.flg_p_3bet and lookup_actions_p.actions = 'RF' and substring(cash_hand_summary.str_aggressors_p from 4 for 1) != substring(cash_hand_summary.str_aggressors_p from 2 for 1), 1, 0])

cnt_p_3bet_face_cold_4b:

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 4 and cash_hand_player_statistics.flg_p_3bet and lookup_actions_p.actions = 'R_%' and substring(cash_hand_summary.str_aggressors_p from 4 for 1) != substring(cash_hand_summary.str_aggressors_p from 2 for 1), 1, 0])

I have created this cokumns, what now?

[kraada]

Try this - I think the problem was just in one of the parenthesis locations:

if( this, format( 'YES ({1})', format_number((cnt_p_3bet_f_cbet_def_action_fold / cnt_p_3bet_f_cbet_def_opp) * 100, 0, false, false)), '' )

[GORANBAXY]

Thanks,
it's working now, how about my cold 4bet question?

I have created this cokumns, what now?

[kraada]

Create a stat using them - put the former over the latter and multiplying by 100 to get the value you want as a percentage.