RE: Trick math for Query 400

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Agreed, I didn't see the requirement for zeros in place of the negative
values.  CASE would handle this...

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: Elvis Budimlic [mailto:ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, January 27, 2005 10:05 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Trick math for Query 400


I don't think ABS would work for his requirement (setting C to zero if B >
A).  CASE statement would work.

-----Original Message-----
Subject: RE: Trick math for Query 400

Take a look at QMQRY, which gives you much more control for data
manipulation.  In SQL, you can use the ABS function to accomplish your goal.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
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.