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?
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?
<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%.
awesome.
Last edited by mgirdley; 03-28-2009 at 01:33 AM.
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 ?
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?
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
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.
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%.
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!