Raventhon
03-12-2011, 11:32 AM
Complete Earn (Totalwin+WCRB+BCFTP$)
[Stat GroupName="Default" ColumnName="Real Earn" ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.0027 AS WCRB;Sum(PH.NetAmountWon)/100.0 as NetWin;sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP;" Evaluate="(WCRB+NetWin)+(FTP*2.5*.0035)" ColumnHeader="RealEarn" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="CompleteFTPEarn" />
Complete EV Earn
[Stat Groupname="Default" ColumnName="EV Earn" ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.0027 AS WCRB;sum(case when EV.SklanskyBucks <> 0 or (EV.SklanskyBucks = 0 and EV.EquityPct = 500) then EV.SklanskyBucks else ph.NetAmountWon end) as SklanskyAdjustedWinnings;sum(round(cast(((cast(pkh .rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP;" Evaluate="(WCRB+(SklanskyAdjustedWinnings/100.0)+(FTP*2.5*.0035))" ColumnHeader="EVEarn" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="EVEarn" />
are both giving "divide by zero" errors
[Stat GroupName="Default" ColumnName="Real Earn" ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.0027 AS WCRB;Sum(PH.NetAmountWon)/100.0 as NetWin;sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP;" Evaluate="(WCRB+NetWin)+(FTP*2.5*.0035)" ColumnHeader="RealEarn" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="CompleteFTPEarn" />
Complete EV Earn
[Stat Groupname="Default" ColumnName="EV Earn" ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.0027 AS WCRB;sum(case when EV.SklanskyBucks <> 0 or (EV.SklanskyBucks = 0 and EV.EquityPct = 500) then EV.SklanskyBucks else ph.NetAmountWon end) as SklanskyAdjustedWinnings;sum(round(cast(((cast(pkh .rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP;" Evaluate="(WCRB+(SklanskyAdjustedWinnings/100.0)+(FTP*2.5*.0035))" ColumnHeader="EVEarn" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="EVEarn" />
are both giving "divide by zero" errors