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
by 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
by 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
by 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
by 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
by 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]
Users browsing this forum: No registered users and 0 guests