PDA

View Full Version : NA error when evaluating



ProsperousOne
05-08-2010, 08:21 AM
I'm having trouble with the below custom stat. If I evaluate just the nomiator or denominator in the Evaluate statement, I get the correct answer. But as soon as I try to divide them, I get "na" as an answer :(. I've even added multiplying by 1.0 to verify both are real, and still no joy:


<Stat ColumnName="SD-NSD EV bb Ratio"
ValueExpressions="
Sum(Case when ph.MaxStreetSeen = 4
then (case when EV.SKlanskyBucks <> 0 or (EV.SklanskyBucks = 0 and EV.EquityPct = 500) then EV.SklanskyBucks
else ph.NetAmountWon
end)/1.0/GT.BigBlind
Else 0
End) as ShowdownEVbbsRatio;
Sum(Case when ph.MaxStreetSeen < 4
then (case when EV.SKlanskyBucks <> 0 or (EV.SklanskyBucks = 0 and EV.EquityPct = 500) then EV.SklanskyBucks
else ph.NetAmountWon
end)/1.0/GT.BigBlind
Else 0
End) as NonShowdownEVbbsRatio"
Evaluate="((ShowdownEVbbsRatio*1.0)/(NonShowdownEVbbsRatio*1.0))"
ColumnHeader="SD NSD\nRatio(Not Working)"
ColumnFormat="0.0"
ColumnWidth="*" />