PDA

View Full Version : Need help with SD/nonSD wins in bb



Baobhan-Sith
01-18-2011, 04:09 AM
Hi,

I'm trying to create custom stats to show SD/nonSD wins in bb instead of $$. I made these stats but they would only work for "by stakes" reports:


<Stat GroupName="Default"
ColumnName="bb w/o SD"
ValueExpressions="Sum(case when ph.MaxStreetSeen = 4 then 0 else ph.netamountwon end)/1.0/GT.BigBlind as TotalbbWOSD"
Evaluate="TotalbbWOSD"
ColumnHeader="bb woSD"
ColumnFormat="0.00"
ColumnWidth="*"
Tooltip="bb won w/o showdown" />

<Stat GroupName="Default"
ColumnName="bb at SD"
ValueExpressions="Sum(case when ph.MaxStreetSeen < 4 then 0 else ph.netamountwon end)/1.0/GT.BigBlind as TotalbbatSD"
Evaluate="TotalbbatSD"
ColumnHeader="bb atSD"
ColumnFormat="0.00"
ColumnWidth="*"
Tooltip="bb won at showdown" />

In any other report I get this error message:

http://www.abload.de/img/errbar7.png

Any help would be greatly appreciated, I'm a total noob when it comes to coding. Thanks in advance.

redlotus
01-20-2011, 11:03 PM
You have to divide by the big blind within the SUM function.

This:

ValueExpressions="Sum(case when ph.MaxStreetSeen = 4 then 0 else ph.netamountwon end)/1.0/GT.BigBlind as TotalbbWOSD"

should be:

ValueExpressions="Sum(case when ph.MaxStreetSeen = 4 then 0 else ph.netamountwon/1.0/GT.BigBlind end) as TotalbbWOSD"

-red

Baobhan-Sith
01-21-2011, 12:52 AM
That's great, thanks alot sir! For those who are interested:


<Stat GroupName="Default"
ColumnName="bb w/o SD"
ValueExpressions="Sum(case when ph.MaxStreetSeen = 4 then 0 else ph.netamountwon/1.0/GT.BigBlind end) as TotalbbWOSD"
Evaluate="TotalbbWOSD"
ColumnHeader="bb woSD"
ColumnFormat="0.00"
ColumnWidth="*"
Tooltip="bb won w/o showdown" />

<Stat GroupName="Default"
ColumnName="bb at SD"
ValueExpressions="Sum(case when ph.MaxStreetSeen < 4 then 0 else ph.netamountwon/1.0/GT.BigBlind end) as TotalbbatSD"
Evaluate="TotalbbatSD"
ColumnHeader="bb atSD"
ColumnFormat="0.00"
ColumnWidth="*"
Tooltip="bb won at showdown" />

<Stat GroupName="Default"
ColumnName="bb/100 w/o SD"
ValueExpressions="Sum(case when ph.MaxStreetSeen = 4 then 0 else ph.netamountwon/1.0/GT.BigBlind end) as TotalbbWOSD"
Evaluate="TotalbbWOSD*100.0/TotalHands"
ColumnHeader="bb/100 woSD"
ColumnFormat="0.00"
ColumnWidth="*"
Tooltip="bb/100 rate w/o showdown" />

<Stat GroupName="Default"
ColumnName="bb/100 at SD"
ValueExpressions="Sum(case when ph.MaxStreetSeen < 4 then 0 else ph.netamountwon/1.0/GT.BigBlind end) as TotalbbatSD"
Evaluate="TotalbbatSD*100.0/TotalHands"
ColumnHeader="bb/100 atSD"
ColumnFormat="0.00"
ColumnWidth="*"
Tooltip="bb/100 rate at showdown" />

http://www.abload.de/img/bbzmiy.png