BvB situations

[viju]

Hello!

I want to make a set of stats for BvB 2bet pot situations. To creata a Flop Cbet stat for SB I've made 2 columns:

cnt_f_cbet_bvb_2betpot = sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_p_open AND cash_hand_summary.str_aggressors_p = '89', 1, 0])
cnt_f_cbet_opp_bvb_2betpot = sum(if[cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_p_open AND cash_hand_summary.str_aggressors_p = '89', 1, 0])

And a positional stat (SB, OOP on Flop):

Cbet Flop Bvb 2betpot = (cnt_f_cbet_bvb_2betpot / cnt_f_cbet_opp_bvb_2betpot) * 100

I created a report to check that both columns work properly, but for some reason the stat doesn't work. What am I doing wrong?

[potamito]

did u rebuild cache after?

[Flag_Hippo]

As potamito mentioned have you rebuilt the custom cache (Database -> Database Management -> Rebuild Cache) after adding your new stat? If that's not the problem then what exactly do you mean when you say it's not working for you?

[viju]

Rebuilding custom cache solved the problem, thank you!