PokerTracker

I am trying to create a "Check Raise Flop CBet" stat by the following

(cnt_f_check_raise_cbet / cnt_f_check_raise_cbet_opp) * 100

cnt_f_check_raise_cbet:

sum(if[holdem_hand_player_statistics.flg_f_check_raise AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])

cnt_f_check_raise_cbet_opp:
sum(if[holdem_hand_player_statistics.flg_f_check AND
holdem_hand_player_statistics.flg_f_cbet_def_opp AND(holdem_hand_player_statistics.cnt_f_raise > 0 OR holdem_hand_player_statistics.cnt_f_call > 0 OR holdem_hand_player_statistics.flg_f_fold), 1, 0])

Format expr:

if (cnt_f_check_raise_cbet_opp < 10, 'X', format('{1} ({2}/{3})',format_number((cnt_f_check_raise_cbet / cnt_f_check_raise_cbet_opp) * 100,0,false,false), cnt_f_check_raise_cbet,cnt_f_check_raise_cbet_opp))


However, when I add this to my HUD, stats for all other players but hero disappears. When I remove the stat from the HUD, everything works. This tells me that the stat is buggy, what is the problem?

At a quick glance the stat looks fine. A minor point:
sum(if[holdem_hand_player_statistics.flg_f_check AND
holdem_hand_player_statistics.flg_f_cbet_def_opp AND(holdem_hand_player_statistics.cnt_f_raise > 0 OR holdem_hand_player_statistics.cnt_f_call > 0 OR holdem_hand_player_statistics.flg_f_fold), 1, 0])

should be functionally equivalent to:

sum(if[holdem_hand_player_statistics.flg_f_check AND holdem_hand_player_statistics.flg_f_cbet_def_opp , 1, 0])

(you must call, raise or fold, so you're always going to have done something when you face a cbet .

That shouldn't cause these problems though. Have you updated your cache since creating the custom statistic? Not doing so would cause the HUD to stop using the cache when you add this stat which would cause all sorts of problems.

Yes I have updated the cache many times since the stat was created. Only for the DB I'm importing into, though.

Other suggestions?

Does your stat work correctly if you add it to one of the built-in reports in the main PT3 application?
e.g. Hands tab, add it to the top report by clicking the spanner/wrench icon to the right. Does that work?

It seems I have solved this issue by simplifyng the format expr.