Re: Trick math for Query 400

This doesn't work for some negative values of A & B.  Given A = -5 & B = -3
then C = -2 with Brendan's formula.  But I doubt Greg's A & B are negative.
Nice formula Brendan.

Paul

-- 
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333

"Brendan Bispham" wrote

> yes, essentially:
>  if a>b then int(a/b) will be > 1, and int(a/b)/int(a/b)=1
>  if a<b then int(a/b) will be 0, and int(a/b)/int(a/b)=0
>  multiply c with the result and you get what you want
>
> And these are the Query defined fields:
>  D  ((a+1)/(b+1))-.5       12     5
>  E  d                       7     0
>  F  e/d                     7     0
>  C  (a-b) * f               7     0