PDA

View Full Version : using individual sites/accounts in a report



bigpumpin
01-05-2010, 03:58 PM
hi,
I'd like to create a rakeback report that takes into account the different %s I get on different sites.

something like:
RAKEBACK = (rake from acctA)*A + (rake from acctB)*B + etc
or (rake from networkA)*A + etc

the code for a basic RB report is
Stat GroupName="Default" ColumnName="Rakeback" ValueExpressions="Sum(PH.RakeAmount)/100.0*0.27 as RakeBackAmount" Evaluate="RakeBackAmount" ColumnHeader="Rakeback" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Rakeback based on 27%"

PH is playerhandle right? would it be possible to swap that out for an individual player?

such as:
ValueExpressions="Sum(bigpumpin.RakeAmount)/100.0*0.27 as RakeBackAmount"

and how would you modify the code to include other screennames?
would it be something like:
ValueExpressions="(Sum(bigpumpin.RakeAmount)/100.0*0.27+Sum(smallpumpin.RakeAmount)/100.0*0.30) as RakeBackAmount"

hopefully someone with programming experience can help me out

cheers