custom column validates but stat using it won't?

[stakkedoff]

i'm trying to create a custom stat for '% a player 4bets when facing a 3bet after attempting to steal'. i'm trying to use a modified version of the 'Fold to PF 3Bet After Steal' stat. the stats column that i think should change is

'cnt_steal_3bet_def_ation_fold'

and it's value expression is

sum(if[cash_hand_player_statistics.flg_steal_att AND
cash_hand_player_statistics.flg_p_3bet_def_opp AND
cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])

so i created a duplicate cash player column called

'cnt_steal_3bet_def_action_4bet_custom'

with the value expression

sum(if[cash_hand_player_statistics.flg_steal_att AND
cash_hand_player_statistics.flg_p_3bet_def_opp AND
cash_hand_player_statistics.enum_p_3bet_action='4bet', 1, 0])

this column validates just fine. it also appears in my column names list on the left of the window. so i create a duplicate of 'Fold to PF 3Bet After Steal' and name it '4Bet after Att to Steal'

the original stats value expression has a numerator that was 'cnt_steal_3bet_def_action_fold' and i replace it with my new column, validated column 'cnt_steal_3bet_def_action_4bet_custom', but when i try to validate the stat itself, i get an invalid value expression pop up in my face. what am i doing wrong?

[stakkedoff]

wait, do i just need to replace '4bet' with 'R' in the value expression of the column? the column validated because the syntax is correct as far as the column editor is concerned but the stat editor catches a logic error in the stats new value expression?

[stakkedoff]

yeah it was literally that. (and a missing opening parathesis)

[Flag_Hippo]

cash_hand_player_statistics.enum_p_3bet_action='F'

cash_hand_player_statistics.enum_p_3bet_action='4bet'

If you want to count when a player is 4betting against a 3bet then you should change 'F' to 'R'.