RE: Trick math for Query 400 - additional info

Greg,

Another option would be to create a SQL view over the file using

CASE 
  WHEN A>B THEN A-B
  ELSE          0
END AS C

to derive your result column. Then you define your query over the view.

I just tried it out and it works fine!

Richard


-----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