Re: Trick math for Query 400

["John Candidi" <jacandidi@xxxxxxxxxxxxxxxxxxxx>]

Right a second query to rip out the negatives and lumtiply them by -1, send
that to a file 2,rip out the positives add them to file 2 then run a 3rd
query to read file 2..Quick fix
----- Original Message ----- 
From: "Greg Wenzloff" <GWenzloff@xxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, January 27, 2005 10:20 AM
Subject: Trick math for Query 400


> I need a simple report to come out of Query but one column must not go
> negative.    In the define results screen this field is defined as a
simple
> C = A - B but we do not want C to be negative. We would like to have a
zero
> instead.   A and B are both 7 digit numbers with no decimals.
>
> Is there any trick math that would do this?
>
> Thanks,
> Greg
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.