RE: Trick math for Query 400 - additional info

Additional comments on my last post......After replying I had forgotten
that you wanted to print a zero in place of the negative.....so this
changes my post, you would need to run 3 queries - first one outputting
the results or all positive values and zeros to a file, then run one for
the negatives where your calc field would have a zero result and you
would have another field for the calc for the purpose of comparing it to
be < 0 in the data selection and output this to the same file WITH the
ADD TO function. Then run a third report printing all of the data from
the newly created file.

        Jim Rubino 
Senior Programmer Analyst 
FIKE CORPORATION (r) 
704 South 10th Street 
Blue Springs, Mo.  64015
*  Direct Dial - (816) 655-4579 
*  Or - (816) 229-6216 Ext. 1079 
*  Jim.Rubino@xxxxxxxx 
world Software Technical Editor for JDEtips


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] 
Sent: Thursday, January 27, 2005 9:20 AM
To: 'midrange-l@xxxxxxxxxxxx'
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.