PDA

View Full Version : Creating Column of Total Winnings (Winnings+Rakeback)



mgirdley
03-27-2009, 05:48 PM
I've attempted to do this and failed. Just want a column/stat that adds two other columns together in the reports section.. any suggestions?

nofolmholdm
03-27-2009, 11:56 PM
<Stat GroupName="Default" ColumnName="TotalWin" ValueExpressions="Sum(PH.RakeAmount)/100.0*0.27 as RakeBackAmount;Sum(PH.NetAmountWon)/100 as NetWin" Evaluate="(RakeBackAmount+NetWin)" ColumnHeader="TotalWin" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="TotalWin" />


You may need to adjust the 0.27 to be your rakeback percent if it isn't 27%.

mgirdley
03-28-2009, 01:28 AM
awesome.

grinder123
07-28-2010, 12:08 PM
Work just with $ rake, but what to change to make correct value with pound and euro? What I should to write instead of PH.RakeAmount ?

grinder123
07-29-2010, 01:37 PM
I see 4 different stats : rake; rake in usd; rake in euro; rake in gbp. The script above took stats from rake, how to change it to rake in usd?

BornTuKill
08-02-2010, 03:45 PM
can some some me how to change the rakeback to rakeshare (MGR) as to total rake paid.It's more accurate for keeping track like in pokertracker

BornTuKill
08-09-2010, 03:31 AM
formula: (sum( holdem_table_session_summary.amt_mgr ))*.75
this is from pt3.
would something like this work. i want to calculate my rakeback using MGR instead of rake paid.Any help appreciated.

lnafziger
08-22-2010, 05:48 PM
So I tried this and got an interesting result. I have a 30% rakeback, so .27 to .30 but it is exactly the same otherwise.

Here are the results from a report after adding it:

Game Type Description Game Size Hands Winnings Rake TotalWin
$0.25/0.5 NL holdem 6 max 55 $105.31 $4.66 $106.40

Unfortunately, if I have a rake of $4.66 then my Rakeback should be $1.398 which when added to $105.31 should be $106.71 and not $106.40 which is more like 23%.

lnafziger
08-22-2010, 06:31 PM
Okay, so I figured this out. In the example given, "Sum(PH.NetAmountWon)/100" will round to the nearest whole dollar which will throw rakeback off on relatively small numbers like this.

Change it to: "Sum(PH.NetAmountWon)/100.0" and all is well!