RE: [sqr-users] rounding to thousand

["radhika reddy" <radhika_05@hotmail.com>]

Thanks to all. All the solutions worked.


>From: kevin.reschenberg@sparkpath.com
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reporting 
>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] rounding to thousand
>Date: Tue, 31 Jan 2006 09:32:46 -0700
>
>let #Result = floor((#Number + 500) / 1000) * 1000
>
>Kevin Reschenberg
>SparkPath Technologies, Inc.
>
>sparkpath.com | sqr-info.com
>
>
> > -------- Original Message --------
> > Subject: [sqr-users] rounding to thousand
> > From: "radhika reddy" <radhika_05@hotmail.com>
> > Date: Tue, January 31, 2006 8:05 am
> > To: sqr-users@sqrug.org
> >
> > 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

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


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