Custom Stat for Rakeback in different currency

[ash0803]

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]

push