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 mgillett » Sun May 24, 2009 8:11 pm
I have two columns and corresponding statistics defined - which are essentially sums of money won over various hands.
I'd like to get a ratio of the two final sums only - is that possible.?
I tried creating a new statistic which divides the two - but I couldn't get it to work - it didn't like the divide for some reason ?- I was thinking it might be because the two sums are over different sets of data.
I hope this makes sense.
Martin
-
mgillett
-
- Posts: 33
- Joined: Fri May 16, 2008 5:27 pm
by WhiteRider » Mon May 25, 2009 4:31 am
Do you have it like this?
Stat1 = columnA / columnB
Stat2 = columnC / columnD
..and you want..
Stat3 = Stat1 / Stat2
?
You would have to do:
Stat3 = (columnA / columnB) / (columnC / columnD)
IF that's not what you mean, please explain in more detail.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 1 guest