Maedinn
02-25-2011, 11:53 AM
I am going to try to explain what i am trying to do ...
I want to calculate a weighted sum of rake base on the site where i played.
Unfortunately usual tables ph or phmsisc do not have the site_id so i can't just do a "ph.site_id". I find out that there is a table named Pokersites but i am not sure how to use it ...
Basically here is my CustomStats i would like to do with an error :
<Stat GroupName="CustomsStats"
ColumnName="TEST"
ValueExpressions="
Sum(case when pokersites.abbreviation=PP THEN ph.RakeAmount ELSE 0 END)/100 as RakePartyPoker;
Sum(case when pokersites.abbreviation=FT THEN ph.RakeAmount ELSE 0 END)/100 as RakeFullTilt;
Sum(case when pokersites.abbreviation=PS THEN ph.RakeAmount ELSE 0 END)/100 as RakePokerstars
"
Evaluate="RakePartyPoker*4+RakeFullTilt+RakePokerstars*2"
ColumnHeader="SP" ColumnFormat="0" ColumnWidth="*" Tooltip="TEST"
/>
I suppose it must not be difficult but i just can't find the right wording.
I want to calculate a weighted sum of rake base on the site where i played.
Unfortunately usual tables ph or phmsisc do not have the site_id so i can't just do a "ph.site_id". I find out that there is a table named Pokersites but i am not sure how to use it ...
Basically here is my CustomStats i would like to do with an error :
<Stat GroupName="CustomsStats"
ColumnName="TEST"
ValueExpressions="
Sum(case when pokersites.abbreviation=PP THEN ph.RakeAmount ELSE 0 END)/100 as RakePartyPoker;
Sum(case when pokersites.abbreviation=FT THEN ph.RakeAmount ELSE 0 END)/100 as RakeFullTilt;
Sum(case when pokersites.abbreviation=PS THEN ph.RakeAmount ELSE 0 END)/100 as RakePokerstars
"
Evaluate="RakePartyPoker*4+RakeFullTilt+RakePokerstars*2"
ColumnHeader="SP" ColumnFormat="0" ColumnWidth="*" Tooltip="TEST"
/>
I suppose it must not be difficult but i just can't find the right wording.