Error 22012: division by zero
Results 1 to 3 of 3

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    Dec 2008
    Posts
    58

    Default Error 22012: division by zero

    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.rakeam ount 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.rakeam ount 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.rakeam ount 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.rakeam ount 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.rakeam ount 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.rakeam ount 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 ?
    Last edited by MoTh; 02-13-2011 at 07:28 PM.

Similar Threads

  1. Replies: 1
    Last Post: 12-17-2010, 03:59 PM
  2. Database division ...
    By rktnan in forum Manager General
    Replies: 1
    Last Post: 09-21-2009, 09:54 PM
  3. Replies: 3
    Last Post: 09-13-2009, 08:48 AM
  4. Error: 22012
    By nugget in forum Manager General
    Replies: 1
    Last Post: 11-10-2008, 01:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •