TheZepper
03-25-2009, 08:33 PM
I've gone round and round trying to customize this stat. I can't seem to find a way to add two ValueExpressions together, either w/in the definitions themselves or to Evaluate the sum, I can't do a nested do loop, and I can't find the right FieldExpression for Went to Showdown to save my life (and ph.MaxStreetSeen = 4)dont cut the mustard.
Here's my last effort.
Stat GroupName="Default" ColumnName="Sum TestG" ValueExpressions="sum(case when WenttoShowdown = true and EV.SklanskyBucks <> 0 then EV.SklanskyBucks else ph.NetAmountWon end)/100.0 as W$SDEVG" Evaluate="W$SDEVG" ColumnHeader="W$SDEVG" ColumnFormat="$0.00" ColumnWidth="61" Tooltip="EV (W$SD EV" />
Really appreciate some help. Wasted a lot of time on this!!!
Here's my last effort.
Stat GroupName="Default" ColumnName="Sum TestG" ValueExpressions="sum(case when WenttoShowdown = true and EV.SklanskyBucks <> 0 then EV.SklanskyBucks else ph.NetAmountWon end)/100.0 as W$SDEVG" Evaluate="W$SDEVG" ColumnHeader="W$SDEVG" ColumnFormat="$0.00" ColumnWidth="61" Tooltip="EV (W$SD EV" />
Really appreciate some help. Wasted a lot of time on this!!!