Error 22012: division by zero

[MoTh]

Hi,

Since the last update I receive an error 22012 with the following custom stats.

Before the update every ran correctly without any error.

<Stat GroupName="Default" ColumnName="Base FTP"
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP"
Evaluate="FTP" ColumnHeader="Base FTP" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points" />
<Stat GroupName="Default" ColumnName="FTP/100"
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand"
Evaluate="FTPHand/1.0/TotalHands*100" ColumnHeader="FTP/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points per 100h" />
<Stat GroupName="Default" ColumnName="BC FTP"
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP"
Evaluate="FTP*2.5" ColumnHeader="BC FTP" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points" />
<Stat GroupName="Default" ColumnName="BC FTP/100"
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand"
Evaluate="FTPHand/1.0/TotalHands*250" ColumnHeader="BC FTP/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points per 100h" />
<Stat GroupName="Default" ColumnName="BC FTP $"
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP"
Evaluate="FTP*2.5*.0035" ColumnHeader="BC FTP $" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="BC FTP $ total" />
<Stat GroupName="Default" ColumnName="$/100 From FTPs (BC)"
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand"
Evaluate="FTPHand/1.0/TotalHands*250*.0035" ColumnHeader="BC $/100 from FTP" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="BC FTP $/100" />
<Stat ColumnName="WCRake"
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.01 AS WCRake"
Evaluate="WCRake" ColumnHeader="WC Rake" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Weighted Contributed Rake (including uncalled bets)" />
<Stat ColumnName="WCRB"
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"
Evaluate="WCRB" ColumnHeader="WC Rakeback" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="WCRB" />
<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" />

Thanks for your help

EDIT : is it possible to downgrade the version of HM ?

[Patvs]

Downgrade: http://faq.holdemmanager.com/questions/426/Download+Links+For+Past+Builds

[lonelycube]

Can you give a little insight why this happens?

The problem must occur during import. (I downgraded after 1.11.06a import to 1.11.05d and the error was still there.)

Can you put up the 1.11.05e for download please.