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
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