croekk
11-08-2010, 08:11 AM
Here you go:
< Stat GroupName="Default" ColumnName="Full Tilt Points"
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP"
Evaluate="FTP" ColumnHeader="FTP" ColumnFormat="0.00"
ColumnWidth="*" Tooltip="Full Tilt Points" />
< Stat GroupName="Default" ColumnName="Full Tilt Points per Hand"
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand"
Evaluate="FTPHand/1.0/TotalHands" ColumnHeader="FTP/Hand" ColumnFormat="0.00"
ColumnWidth="*" Tooltip="Full Tilt Points per Hand" />
My FTPs today according to the stat: 100.72
Real FTPs: 101.25
So it's pretty accurate. And I'm pretty sure the difference is only a result of closing a table too early when the hand wasn't over yet.
< Stat GroupName="Default" ColumnName="Full Tilt Points"
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP"
Evaluate="FTP" ColumnHeader="FTP" ColumnFormat="0.00"
ColumnWidth="*" Tooltip="Full Tilt Points" />
< Stat GroupName="Default" ColumnName="Full Tilt Points per Hand"
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand"
Evaluate="FTPHand/1.0/TotalHands" ColumnHeader="FTP/Hand" ColumnFormat="0.00"
ColumnWidth="*" Tooltip="Full Tilt Points per Hand" />
My FTPs today according to the stat: 100.72
Real FTPs: 101.25
So it's pretty accurate. And I'm pretty sure the difference is only a result of closing a table too early when the hand wasn't over yet.