Why is this not taking into account the *.66

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

Why is this not taking into account the *.66

Postby OTPlayboy » Sat Apr 14, 2012 6:58 pm

if(live_amt_ante = 0, format_number(live_amt_stack / live_amt_bb, 0, false, false), format_number((live_amt_stack / (live_amt_bb + live_amt_sb + (live_amt_ante * live_cnt_players))*.66), 0, false, false))
OTPlayboy
 
Posts: 4
Joined: Fri Apr 13, 2012 5:42 am

Re: Why is this not taking into account the *.66

Postby kraada » Sun Apr 15, 2012 9:05 am

I don't see any reason why it wouldn't be - is it giving you the same results as if it wasn't there at all?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Why is this not taking into account the *.66

Postby OTPlayboy » Thu Apr 19, 2012 8:28 am

ya stat doesn't change either way
OTPlayboy
 
Posts: 4
Joined: Fri Apr 13, 2012 5:42 am

Re: Why is this not taking into account the *.66

Postby WhiteRider » Fri Apr 20, 2012 3:33 am

I suspect that the issue is more likely to do with the IF statement, or the value of "live_amt_ante".
Try changing "live_amt_ante = 0" to "live_amt_ante != 0" (not equal) to force it to use the "else" part of the IF statement and see if the .66 is used then.
If so, we'll need to find out why the ante amount isn't being set.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 8 guests