Average Rakeback per Hand

[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?

[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.

[gspott]

thanks so far kradaa,

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



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

[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 . . .