Re: negative zero

[Bob Helm <Bob.Helm@MEDIWARE.COM>]

Strange. This is lengthy, but maybe you could convert it to a string, then
look at the first one (or two) characters?



-----Original Message-----
From: Sarah Moore [mailto:smoore@NWTC.TEC.WI.US]
Sent: Monday, October 15, 2001 10:44 AM
To: SQR-USERS@list.iex.net
Subject: Re: negative zero


Well the problem is that I may have a valid negative number i.e: -123.00,
therefore I wouldn't want to always change it to a postive.  I tried the
abs function and it didn't do anything.  I also tried encoding a negative
sign and a zero, and doing a find for each.  The finds work, but for some
reason do not work if I embed if statements (if $neg = 'y' and $zero
= 'y').




                    Rick_Creel@AON
                    CONS.COM             To:     SQR-USERS@list.iex.net
                    Sent by:             cc:
                    "Discussion of       Subject:     Re: negative zero
                    SQR,
                    Brio
                    Technology's
                    database
                    reporting
                    language"
                    <SQR-USERS@lis
                    t.iex.net>


                    10/15/01 10:17
                    AM
                    Please respond
                    to sqr-users






Could you multiply it by -1  ?
Or, could you use the absolute value (ABS) function?





Sarah Moore <smoore@NWTC.TEC.WI.US> on 10/15/2001 11:09:33 AM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rick Creel/IT/Aon Consulting)

Subject:  negative zero



Is there a quick and easy way to change  -0.00 to 0.00 (result field from
add) ? I'm having trouble identifying the -0.0 value within the field to
change it to a positive...