Raising a stat to a power

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

Raising a stat to a power

Postby Leader_ » Sun May 10, 2009 5:56 pm

I was wondering if there is a way to create a custom stat that raises something to a power (based on the number of hands). Alternately is there some way of using a loop to create a statistic? I'm sure these things are possible in SQL but I'm not sure how to implement them to get a custom stat.
Leader_
 
Posts: 6
Joined: Wed Jun 04, 2008 3:37 am

Re: Raising a stat to a power

Postby WhiteRider » Sun May 10, 2009 6:01 pm

I don't think you can loop, but you can use ^ to raise to a power.
e.g. 2 ^ 3 = 8
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Raising a stat to a power

Postby Leader_ » Sun May 10, 2009 6:04 pm

WhiteRider wrote:I don't think you can loop, but you can use ^ to raise to a power.
e.g. 2 ^ 3 = 8


When I try this though by typing it into the text box under "Value expression:" and click "Validate." PT says it's not valid.
Leader_
 
Posts: 6
Joined: Wed Jun 04, 2008 3:37 am

Re: Raising a stat to a power

Postby WhiteRider » Sun May 10, 2009 6:07 pm

Ah yes, I think you can only do it in columns, not statistics.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Raising a stat to a power

Postby Leader_ » Sun May 10, 2009 6:16 pm

WhiteRider wrote:Ah yes, I think you can only do it in columns, not statistics.


ok thanks I might be able to figure it out from there. I'll let you know if I run into any issues.
Leader_
 
Posts: 6
Joined: Wed Jun 04, 2008 3:37 am


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

Who is online

Users browsing this forum: No registered users and 0 guests