PDA

View Full Version : Custom stats total



Kerith
01-24-2009, 04:02 PM
I got a custom stat from 2+2 that shows me the player points per 100 hands. When I run a report by stakes and have multiple stakes it adds those numbers up in the bottom (like it does for hands, $ and rake) although it should be a weighted average (like BB/100, VPIP and PFR).
How do I have to modify the custom stats to that?

morny
01-24-2009, 05:41 PM
Can you attach the file so i can have a look please

Kerith
01-25-2009, 03:08 PM
I attached the CustomStats.txt that I got from 2+2 with a lot of stats in it. The part that got me asking is:

iPoker / Betfred VCPs per 100 hands at each VIP level:
<Stat GroupName="Default" ColumnName="Betfred VCPs/100 VIP6" ValueExpressions="(Sum((case when PKH.RakeAmount between 10 and 25 then 0.25 else 0 end)+(case when PKH.RakeAmount between 26 and 50 then 2 else 0 end)+(case when PKH.RakeAmount between 51 and 100 then 4 else 0 end)+(case when PKH.RakeAmount between 101 and 150 then 7 else 0 end)+(case when PKH.RakeAmount between 151 and 200 then 9 else 0 end)+(case when PKH.RakeAmount between 201 and 250 then 13 else 0 end)+(case when PKH.RakeAmount between 251 and 300 then 15 else 0 end)+(case when PKH.RakeAmount >= 301 then 15 else 0 end))/1.0)/Sum(0.01) as Betfred6100" Evaluate="Betfred6100" ColumnHeader="Betfred VCPs /100 VIP6" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Betfred VCPs per 100 hands at VIP6" />

Rvg72
01-27-2009, 01:41 AM
I think the custom stats is setup wrong. It should looking something like this:

&lt;Stat GroupName="Default" ColumnName="Better Points/100 VIP1" ValueExpressions="(Sum((case when PKH.RakeAmount between 25 and 50 then 1 else 0 end)+(case when PKH.RakeAmount between 51 and 100 then 2 else 0 end)+(case when PKH.RakeAmount between 101 and 150 then 4 else 0 end)+(case when PKH.RakeAmount between 151 and 200 then 6 else 0 end)+(case when PKH.RakeAmount between 201 and 250 then 8 else 0 end)+(case when PKH.RakeAmount >= 251 then 10 else 0 end))/1.0) as Better1100" Evaluate="Better1100*100.0/TotalHands" ColumnHeader="Better Points /100 VIP1" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Better Points per 100 hands at VIP1" />

Previously it was just looking at Total Points / 100 but it really should be Total Points / Hands * 100. The total at the bottom will now work as well

Roy