I extracted the SELECT statement to a new file and tested it in response to
his question re: select. When I replaced my IFEQ clause with yours I get
the same error after the first few rows (probably until it hits a zero
value).
t1.hhn t2.eid t2.sid t2.dserv t2.servcod t2.numclie
---------- ---------- ---------- ---------- ---------- ----------
98231 123 151 07/06/2001 6500 1
98231 123 151 07/07/2001 9933 1
992984 122 114 07/05/2001 9933 1
992984 122 114 07/05/2001 6500 1
994103 62 120 07/05/2001 6500 1
ERROR- Division by zero. (2553)
Dave
----- Original Message -----
From: "Bill Downall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 4:18 PM
Subject: Re: IFEQ question
> Dave,
>
> I think the innermost expression gets evaluated first.
>
> Instead of this:
>
> (IFEQ(t2.numclient, 0 , 0 ,(t2.unit / t2.numclient)))
>
> See if this works better:
>
> (t2.unit / (IFEQ(t2.numclient,0,1,t2.numclient))
>
> Bill
>
>
>
> On Sun, 5 Aug 2001 15:32:08 -0400, David Ebert wrote:
>
> >The IFEQ statement, if I understand it correctly, is supposed to
> exclude the
> >zero records (arg 4) because the numclient value (arg1) is not equal
> to zero
> >(arg2).
> >
>
>
>
>
