3 Bet All in and 3 Bet Not all Stats

[Zito]

What's the line before that in the log? That line just says it closed the invalid expression window, but doesn't give the reason why it wasn't valid.

[- Main -][StatManager] Variable expression not valid: Unknown token encountered: cnt_p_3bet_def_action_fold_when_open_raised_17_30
[- Main -][WindowDialog] Opening Dialog: Invalid Expression (0018DE18)

[kraada]

Try replacing:
((cnt_p_3bet_def_action_fold_when_open_raised_17_30 - cnt_p_3bet_ai_def_action_fold_when_open_raised_17_30) / cnt_p_3bet_def_opp_17_30)*100

with:
format_number(((cnt_p_3bet_def_action_fold_when_open_raised_17_30 - cnt_p_3bet_ai_def_action_fold_when_open_raised_17_30) / cnt_p_3bet_def_opp_17_30) * 100, 2, false, false)

and let me know if that works any better for you.

[Zito]

Still getting : "Variable expression not valid: Unknown token encountered: cnt_p_3bet_def_action_fold_when_open_raised_17_30"

[kraada]

Could you try also replacing "-" with "0" and let me know if it makes any difference?

[Zito]

Could you try also replacing "-" with "0" and let me know if it makes any difference?

I still get the same error.

[kraada]

The only other thing I can think is that "cnt_p_3bet_def_action_fold_when_open_raised_17_30" might be too long of a name. Try something shorter and simpler and see if that makes any difference (and that would fix any typo problems too).

[Zito]

My F'up on this one, cnt_p_3bet_def_action_fold_when_open_raised_17_30 columns wouldn't validate because I hadn't even made them, or bother to check until yesterday that I had.

[kraada]

That makes a lot of sense. Since you pasted the definition earlier I thought you checked that. At least it's an easy fix

[Zito]

Not getting the correct results with these stats. Fold to PF 3Bet All-In After Raise recognizes the opportunity buts gives an incorrect result e.g it counts a fold as a call. Fold to PF 3Bet Non All-In After Raise is counting 3bet All-ins.

Fold to PF 3bet all in after openraise

Code: Select all

(cnt_p_3bet_ai_def_action_fold_when_open_raised / cnt_p_3bet_ai_def_opp_when_open_raised) * 100

Columns:
cnt_p_3bet_ai_def_action_fold_when_open_raised

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_def_opp AND tourney_hand_player_statistics.flg_p_first_raise AND ((amt_p_3bet_facing + amt_p_raise_made) >= 0.4 *  amt_p_effective_stack) , 1, 0])

cnt_p_3bet_ai_def_opp_when_open_raised

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_def_opp AND tourney_hand_player_statistics.flg_p_first_raise AND ((amt_p_3bet_facing + amt_p_raise_made) >= 0.4 *  amt_p_effective_stack) , 1, 0])

Fold to PF 3bet not all in after open raise
[code]((cnt_p_3bet_def_action_fold_when_open_raised - cnt_p_3bet_ai_def_action_fold_when_open_raised) / cnt_p_3bet_def_opp_when_open_raised) * 100

[kraada]

tourney_hand_player_statistics.flg_p_3bet_def_opp just means you faced a 3bet, not that you folded to it. You don't have anything in your fold column that specifies folding to a 3bet.

You can specify that with: tourney_hand_player_statistics.enum_p_3bet_action = 'F'