Rakeback for different sites

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Rakeback for different sites

Postby skatemaza » Thu Sep 11, 2008 7:05 am

Hello, I want create stats for rakeback, but i will differenciate there between the different pokersites.

I have create the colum "amt_rb" with the expression of "(amt_mgr * 0.4)" and then i have a statistic names rakeback with the value Expression with "amt_rb"

That works, but i will have rakeback for titanpoker with 40% and FTP for example with 30%.

I hope you can help me.

with best regards
Martin
skatemaza
 
Posts: 21
Joined: Wed Sep 03, 2008 10:07 am

Re: Rakeback for different sites

Postby WhiteRider » Thu Sep 11, 2008 9:49 am

The easiest thing to do would be to create 2 separate stats, but you could do it in one with an IF statement.
Something like
if ( lookup_from_id( id_site, 'siteabbr' ) = 'FTP', (amt_mgr * 0.3), (amt_mgr * 0.4) )

You would have to do this in the Statistic not the Column because you can only use the lookup_from_id function in the Statistic.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 13 guests