PDA

View Full Version : BBs won/lost



El Helado
03-13-2009, 05:54 PM
Hi.

Can someone please write what I shall add in CustomStats.txt to be able to show BBs won/lost.

I should be pretty easy somehow since it is hands*(BB/100 divided by 100)

nofolmholdm
03-21-2009, 05:40 PM
Like this?

<Stat GroupName="Default" ColumnName="BB Won" ValueExpressions="Sum(PH.NetAmountWon/1.0/GT.BigBlind) as NetWinbb" Evaluate="(NetWinbb)/2" ColumnHeader="BB Won" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Total BB Won" />

El Helado
03-21-2009, 08:16 PM
Like this?

<Stat GroupName="Default" ColumnName="BB Won" ValueExpressions="Sum(PH.NetAmountWon/1.0/GT.BigBlind) as NetWinbb" Evaluate="(NetWinbb)/2" ColumnHeader="BB Won" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Total BB Won" />

Thank you! It looks great.

Torono
03-23-2009, 05:39 PM
Is it possible to do this for $ won/lost? Apologies if this is already a stat that I am just unfamiliar with.

nofolmholdm
03-23-2009, 05:43 PM
Is it possible to do this for $ won/lost? Apologies if this is already a stat that I am just unfamiliar with.

Isn't that just the Net Amount Won stat? '$' is the column header?

Torono
03-23-2009, 06:26 PM
Isn't that just the Net Amount Won stat? '$' is the column header?

I thought net amount be the difference between total won & total lost?

nofolmholdm
03-24-2009, 10:07 AM
I thought net amount be the difference between total won & total lost?

so you want (total amount won) divided by (total amount lost) ? If so I'll post it in a few hours (at work now.)

Torono
03-24-2009, 04:33 PM
so you want (total amount won) divided by (total amount lost) ? If so I'll post it in a few hours (at work now.)

I don't think my last post made much sense. What I'm attempting to ask is if it's possible to get 2 separate stats:
total amount won
total amount lost

Re-reading your post again, yes, the difference between these two stats would result in the net amount won (or lost). I must not have been thinking clearly when I made my previous confusing post. Also, I wasn't using the "/" to indicate I wanted them divided, so I apologize for being unclear.

nofolmholdm
03-24-2009, 07:14 PM
&lt;Stat GroupName="Default" ColumnName="Losses" ValueExpressions="Sum(case when PH.NetAmountWon < 0 then ph.netamountwon else 0 end)/100. as Losses" Evaluate="Losses" ColumnHeader="Losses" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Losses" /&gt;

&lt;Stat GroupName="Default" ColumnName="Winnings" ValueExpressions="Sum(case when PH.NetAmountWon >= 0 then ph.netamountwon else 0 end)/100. as Winnings" Evaluate="Winnings" ColumnHeader="Winnings" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Winnings" /&gt;