Page 1 of 1

Average Rakeback per Hand

PostPosted: Thu Mar 12, 2009 7:38 pm
by gspott
hi,

i want to define a stat for the "General"-tab that presents the average rakeback per hand for the different limit with assumed 27%.

My first try: Section "Holdem Cash Sessions"

Column:
amt_rbh
Expression:
sum( holdem_table_session_summary.amt_mgr / holdem_table_session_summary.cnt_hands ) * 0.27


Statistic:
Rakeback/Hand
Value Expression:
amt_ftrbh


But this didnt work out. As result i get the Total Rakeback and not the Rakeback divided by hands played for the current limit :roll:

Anyone ideas?

Re: Average Rakeback per Hand

PostPosted: Fri Mar 13, 2009 10:00 am
by kraada
amt_mgr is already a sum of the mgr for the sessions in that section, and cnt_hands is defined as a different column.

So you can just do:

(amt_mgr / cnt_hands) * 0.27 as the column definition.

Re: Average Rakeback per Hand

PostPosted: Fri Mar 13, 2009 2:08 pm
by gspott
thanks so far kradaa,

but that didnt work.....
all i got was this error-message:



http://img17.imageshack.us/img17/3719/errorvnr.jpg

Re: Average Rakeback per Hand

PostPosted: Fri Mar 13, 2009 3:42 pm
by kraada
Hrm, I guess you can't do that; I'm surprised the column validates then. You're not going to be able to put the amt_mgr inside of the sum() so I'm not actually sure if you can do this. Though once you have total rakeback and total hands there, you can always just divide one by the other. I know it's not a neat solution but it would work . . .