Re: Absolute amount in query

Folks

A little googling got a formula for this -
:
|x| = ((x / (x +.0000001)) * -2 + 1) * x

division is integer division - or should have an int or floor function around it - int(x / (x +.0000001)) is 1 for negative numbers, 0 for positive ones

Now, is there an INT function in Query/400? I rarely use it anymore, SQL has all this stuff already.

This is the link where it is discussed, if you want to understand it better

http://www.terryblackburn.us/WildIdeas/fable.htm

In that article the internal parentheses on the denominator are omitted, as below

|x| = ((x / x +.0000001) * -2 + 1) * x

and that will not work.

I think the minuscule amount just needs to have more decimal places than your input number "x"

HTH
Vern

At 07:57 AM 12/13/2007, you wrote:

specify function ABS()..... ABS(:hostvar) or ABS(column)

--
Regards,

Michael Rosinger
Systems Programmer / DBA
Computer Credit, Inc.
640 West Fourth Street
Winston-Salem, NC 27101
336-761-1524
m rosinger at cciws dot com
"Tomasz Skor¿a" <t.skorza@xxxxxxxxxxx> wrote in message
news:mailman.22805.1197539863.4459.midrange-l@xxxxxxxxxxxxxxx
> Hi guys
>
> Is it possible to get new field "absolute amount" in QUERY/400 for any
> other
> numeric fields? (WRKQRY)
>
> I'mean 1000 for field=-1000 and also 1000 for field=1000
>
> Regards
>
> --
> Tomek
>
>



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