PDA

View Full Version : New update broke my CustomStats



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

fopah
03-13-2011, 04:34 PM
Hi,
I put both of these in my custom stats individually in my customstats and they seemed to work.

I would copy your custom stats file and create a new one and test them individually to see if one is coming out incorrectly or if there is an error in another stat.

MoTh
03-20-2011, 07:58 AM
Same here for both of them.