Eliminating N/As

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Eliminating N/As

Postby Messaa » Fri Mar 13, 2009 8:31 am

I am trying to elminate all N/A-symbols from my HUD. It seems to me that these appear when division by zero is made, is this correctly understood?

For instance, my format expr for my "Fold to Real 3bet in Position = 3" stat reads:

if (cnt_p_3bet_real_def_pos3_opp < 10 OR cnt_p_3bet_real_def_pos3_opp = 0, 'X', format('{1} ({2}/{3})',format_number((cnt_p_3bet_real_def_pos3_action_fold / cnt_p_3bet_real_def_pos3_opp) * 100,0,false,false), cnt_p_3bet_real_def_pos3_action_fold,cnt_p_3bet_real_def_pos3_opp))

Which should tell the HUD to display X when cnt_p_3bet_real_def_pos3_opp is zero. However, the stat still reads "N/A". What is the problem?
Messaa
 
Posts: 36
Joined: Tue May 27, 2008 1:55 am

Re: Eliminating N/As

Postby kraada » Fri Mar 13, 2009 10:37 am

If you click the Settings button on the main Texas Holdem tab you can change the N/A text to whatever you'd like. If you want it to be a - or something, you can just put that there (or leave it a space if you want nothing to show). I believe the N/A text takes precedence over the formatting tab.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 4 guests