PDA

View Full Version : Custom Stat for Rakeback in different currency



ash0803
12-18-2010, 12:07 AM
Hi

I can see from previous examples to get a custom stat to show rakeback you would have something like the following:


<Stat GroupName="Default" ColumnName="RB" ValueExpressions="Sum(PH.RakeAmount)/100.0*0.5 as RakeBackAmount" Evaluate="RakeBackAmount" ColumnHeader="Rakeback"
ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Rakeback based on 50%" />

However, this doesn't take into account the currency. I have noticed that the gt table has the currency_id and I have noticed that the currency table contains the actual conversion rate. However, I can't seem to access the currency table and can't find information on how to do the following


<Stat GroupName="Default" ColumnName="RB" ValueExpressions="Sum(PH.RakeAmount*currency.current_rate_in_usd)/100.0*0.5 as RakeBackAmount" Evaluate="RakeBackAmount" ColumnHeader="Rakeback"
ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Rakeback based on 50%" />

Can anyone help? Much appreciated

Schorscheee
12-26-2010, 09:31 AM
push