Problem with Custom Stat - Rakeback

[PK23]

I created this customer stat:
if ( lookup_from_id( id_site, 'siteabbr' ) = 'FTP', (amt_mgr * 0.27) )

Shouldn't this only show a non zero value if the site is FTP? I have sessions from both FTP and Stars and when I don't filter by site, MGR at Stars is calculated in the result.

See below for a screenshot. As you can see, I've filtered to show only Stars result. Thus, my Rakeback should be zero if I've written my expression correctly, right?

[ img ]

[ img ]

[PK23]

Here are links to the images since resizing them here makes them unreadable:


http://img.villagephotos.com/p/2005-7/1045377/SHOT.jpg

http://img.villagephotos.com/p/2005-7/1045377/SHOT2.jpg

[WhiteRider]

I don't know for sure, but your IF statement doesn't have an ELSE clause, so you could try:
if ( lookup_from_id( id_site, 'siteabbr' ) = 'FTP', (amt_mgr * 0.27), 0 )

[PK23]

Had already tried that and it provides the same result.

[WhiteRider]

OK, please export your stat and attach the file (zipped) to a ticket on the Support system , and link to this thread in the reference field of the ticket so that we can investigate.

[Eric Poker]

Maybe is gonna help

This is my rakeback calculation for SnGs
amt_rakeback

Code: Select all

sum(if[tourney_holdem_summary.id_site=300 ,tourney_holdem_summary.amt_rake * 0.27,if[tourney_holdem_summary.id_site=400 ,tourney_holdem_summary.amt_rake * 0.30,0]])

site 300 = ftp
site 400 =ipoker

so for you in Session Summary
amt_rakeback (column)

Code: Select all

sum(if[holdem_hand_summary.id_site=300 ,holdem_hand_summary.amt_mgr * 0.27,0])

Hope it help

[Eric Poker]

You are using the wrong "if"
you should use if[holdem_hand_summary.id_site for Single Session
and sum(if[holdem_table_session_summary.id_site=300 for Sumarry of Sessions

I did it for you
I think this is working but i havn't tested

http://www.reloadfiles-host.net/files/1224314755.zip

import both

[WhiteRider]

You're quite right - thanks Eric.

[Bunghole]

Sorry to ask again, but the solution that was posted didn't work...

So could you please explain to me, how to add the rakeback statistics?

I play at iPoker with 45% RB, at full tilt with 27% and at Stars with 0% RB

So i go to Configure -> Configure Stats -> Statistics -> New but what's next?

(I would like to see the Rakeback column in the General and the Sessions section)

[WhiteRider]

You will need to create your stat in the 'holdem cash player statistics' section, so select that first.
Then you will need to create a Column to do the calculation and a Statistic to display it.
Try downloading one of the rakeback stats from the Repository and duplicating it then editting your copy.

See also the Custom Statistics and Reports FAQ.