Columns verify, Stat verifies, HUD chokes with error. HALP!

[kraada]

What stat are you trying to edit the color ranges on and seeing it greyed out?

[bodhisoma]

What stat are you trying to edit the color ranges on and seeing it greyed out?

It's the stat created by the below definitions. What's weird is that I have another, extremely similiar stat that I CAN color code and, AFAIK, the only difference between the old one (which I can color code) and the one below is a slight adjustment of the stat definition. More specifically, the older one was based on some code BenHarvey generously provided but had unnecessary if[if[ ]] nesting, which I removed.

Let me know if it'd be easier for me to just export the stat and post a link to it.

Code: Select all

COLUMNS
8_to_30bb

cnt_f_fold_8_to_30bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND tourney_hand_player_statistics.flg_f_fold, 1, 0])

cnt_f_call_8_to_30bb
sum(if[if[tourney_hand_player_statistics.cnt_f_call > 0] AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8, 1, 0])

cnt_f_bet_8_to_30bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND tourney_hand_player_statistics.flg_f_bet, 1, 0])

cnt_f_raise_8_to_30bb
sum(if[if[tourney_hand_player_statistics.cnt_f_raise > 0] AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8, 1, 0])

cnt_t_fold_8_to_30bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND tourney_hand_player_statistics.flg_t_fold, 1, 0])

cnt_t_call_8_to_30bb
sum(if[if[tourney_hand_player_statistics.cnt_t_call > 0] AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8, 1, 0])

cnt_t_bet_8_to_30bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND tourney_hand_player_statistics.flg_t_bet, 1, 0])

cnt_t_raise_8_to_30bb
sum(if[if[tourney_hand_player_statistics.cnt_t_raise > 0] AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8, 1, 0])

cnt_r_fold_8_to_30bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND tourney_hand_player_statistics.flg_r_fold, 1, 0])

cnt_r_call_8_to_30bb
sum(if[if[tourney_hand_player_statistics.cnt_r_call > 0] AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8, 1, 0])

cnt_r_bet_8_to_30bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND tourney_hand_player_statistics.flg_r_bet, 1, 0])

cnt_r_raise_8_to_30bb
sum(if[if[tourney_hand_player_statistics.cnt_r_raise > 0] AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8, 1, 0])

cnt_vpip_8_to_30bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND tourney_hand_player_statistics.flg_vpip, 1, 0])

cnt_hands_8_to_30bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND tourney_hand_player_statistics.id_hand > 8, 1, 0])

cnt_walks_8_to_30bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND lookup_actions_p.action = '', 1, 0])

STATS

RAFq 8 to 30bb
format_number(((((cnt_f_bet_8_to_30bb + cnt_f_raise_8_to_30bb + cnt_t_bet_8_to_30bb + cnt_t_raise_8_to_30bb + cnt_r_bet_8_to_30bb + cnt_r_raise_8_to_30bb) / (cnt_f_call_8_to_30bb + cnt_f_fold_8_to_30bb + cnt_t_call_8_to_30bb + cnt_t_fold_8_to_30bb + cnt_r_call_8_to_30bb + cnt_r_fold_8_to_30bb + cnt_f_bet_8_to_30bb + cnt_f_raise_8_to_30bb + cnt_t_bet_8_to_30bb + cnt_t_raise_8_to_30bb + cnt_r_bet_8_to_30bb + cnt_r_raise_8_to_30bb)) * 100) * ((cnt_vpip_8_to_30bb / (cnt_hands_8_to_30bb - cnt_walks_8_to_30bb)) * 100)) / 1000, 0, false, false)

[kraada]

amt_p_effective_stack is no longer in tourney_hand_summary and has moved to tourney_hand_player_statistics - you'll want to update these columns accordingly and that should fix things.

[bodhisoma]

amt_p_effective_stack is no longer in tourney_hand_summary and has moved to tourney_hand_player_statistics - you'll want to update these columns accordingly and that should fix things.

I'm sorry kraada, I made a mistake. That was the old code and not what I was using, I accidentally generated the above code by going to the wrong directory and running my script.

The code that my columns/stats are based off (and do not allow color coding) is as follows:

Code: Select all

COLUMNS
8_to_30bb

cnt_f_fold_8_to_30bb
sum(if[tourney_hand_player_statistics.flg_f_fold AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_f_call_8_to_30bb
sum(if[tourney_hand_player_statistics.cnt_f_call > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_f_bet_8_to_30bb
sum(if[tourney_hand_player_statistics.flg_f_bet AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_f_raise_8_to_30bb
sum(if[tourney_hand_player_statistics.cnt_f_raise > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_t_fold_8_to_30bb
sum(if[tourney_hand_player_statistics.flg_t_fold AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_t_call_8_to_30bb
sum(if[tourney_hand_player_statistics.cnt_t_call > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_t_bet_8_to_30bb
sum(if[tourney_hand_player_statistics.flg_t_bet AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_t_raise_8_to_30bb
sum(if[tourney_hand_player_statistics.cnt_t_raise > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_r_fold_8_to_30bb
sum(if[tourney_hand_player_statistics.flg_r_fold AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_r_call_8_to_30bb
sum(if[tourney_hand_player_statistics.cnt_r_call > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_r_bet_8_to_30bb
sum(if[tourney_hand_player_statistics.flg_r_bet AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_r_raise_8_to_30bb
sum(if[tourney_hand_player_statistics.cnt_r_raise > 0 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30, 1, 0])

cnt_vpip_8_to_30bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND tourney_hand_player_statistics.flg_vpip, 1, 0])

cnt_hands_8_to_30bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND tourney_hand_player_statistics.id_hand > 8, 1, 0])

cnt_walks_8_to_30bb
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) > 8 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 30 AND lookup_actions_p.action = '', 1, 0])

STATS

RAFq 8 to 30bb
((((cnt_f_bet_8_to_30bb + cnt_f_raise_8_to_30bb + cnt_t_bet_8_to_30bb + cnt_t_raise_8_to_30bb + cnt_r_bet_8_to_30bb + cnt_r_raise_8_to_30bb) / (cnt_f_call_8_to_30bb + cnt_f_fold_8_to_30bb + cnt_t_call_8_to_30bb + cnt_t_fold_8_to_30bb + cnt_r_call_8_to_30bb + cnt_r_fold_8_to_30bb + cnt_f_bet_8_to_30bb + cnt_f_raise_8_to_30bb + cnt_t_bet_8_to_30bb + cnt_t_raise_8_to_30bb + cnt_r_bet_8_to_30bb + cnt_r_raise_8_to_30bb)) * 100) * ((cnt_vpip_8_to_30bb / (cnt_hands_8_to_30bb - cnt_walks_8_to_30bb)) * 100)) / 1000

[kraada]

Nothing else particularly jumps out at me. The only thought that comes to mind that might be worth trying is to try creating variables in the Variables area to simplify down the value expression to something a lot closer to a built in stat and see if that makes any difference.

[bodhisoma]

Nothing else particularly jumps out at me. The only thought that comes to mind that might be worth trying is to try creating variables in the Variables area to simplify down the value expression to something a lot closer to a built in stat and see if that makes any difference.

I create a stat, "Junk", designed to see what breaks the color coding in the HUD and I was kind of surprised at what I found.

The stat is defined as follows:

cnt_f_fold + cnt_f_call + cnt_f_bet + cnt_f_raise

Of course these stats are native and not custom at all.

I've placed the "Junk" stat into a HUD and lo!, Color Ranges is still greyed out.

I don't get it. The stat resolves to a number, how can it not be color codeable?

Is there some kind of log I can send you, something that tells us what process is telling that button to be greyed out?

[kraada]

Export that stat and send it to us via the support system and reference this thread and we'll look into it for you.

[bodhisoma]

Did that. Thanks kraada.

[bodhisoma]

Just in case anyone else is running into the same problems, the solution was to change the stat's format type to "number."