RE: [sqr-users] rounding to thousand

["Jim Womeldorf" <jwomeldo@fastenal.com>]

If you have Oracle the following will work.  Of course it requires a
database hit for each calculation.
Too bad the SQR folks didn't think of using a negative number for this
purpose.

let #x = 6590.78
show #x
begin-select
round(#X,-3) &rounded
    show  &rounded   
from dual
end-select 

Jim

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org] On Behalf Of
radhika reddy
Sent: Tuesday, January 31, 2006 10:06 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] rounding to thousand

Hi,

  I have to round a number to thousands like the following:

Number          Result
6590.78         7000.00
5343.00         5000.00
3000.00         3000.00

I am not able to achieve this through Round function. Can you tell me is
there any function or how to achieve this.

Thanks,
Radhika

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now! 
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users