"r" <r@r.com> wrote in message news:uCwfP4fZFHA.3032@TK2MSFTNGP10.phx.gbl...
> How can I avoid this?
>
> I have the following calculations in a view:
>
> Data017_all.MTD_StkOrdAmt / Data017_all.MTD_TotOrdAmt * 100 AS MTD_OSO,
> Data017_all.YTD_StkOrdAmt / Data017_all.YTD_TotOrdAmt * 100 AS YTD_OSO,
>
>
> ...if the second number (the _TotOrdAmt) is 0, I get the divide by zero
> error. Is there some way to write this so that if that number is 0 the
> resulting value is 0 and not an error???
>
> Thanks in advance...
>
>

"Roman JR." wrote:

> Hi,
>
> You can do something like this
>
> ISNULL((Data017_all.MTD_StkOrdAmt/CASE WHEN Data017_all.MTD_TotOrdAmt = 0
> THEN NULL END)*100, 0)
>
> Basically, covevert the 0 to NULL, this way you will avoid Divide by zero
> error.
> Then if the result of devision is NULL, use ISNULL to convert the NULL value
> to 0
>
> That is it.
>
> Roman JR.
>
> "r" wrote:
>
> > How can I avoid this?
> >
> > I have the following calculations in a view:
> >
> > Data017_all.MTD_StkOrdAmt / Data017_all.MTD_TotOrdAmt * 100 AS MTD_OSO,
> > Data017_all.YTD_StkOrdAmt / Data017_all.YTD_TotOrdAmt * 100 AS YTD_OSO,
> >
> >
> > ....if the second number (the _TotOrdAmt) is 0, I get the divide by zero
> > error. Is there some way to write this so that if that number is 0 the
> > resulting value is 0 and not an error???
> >
> > Thanks in advance...
> >
> >