RE: [sqr-users] rounding to thousand

["Elvis Pressly" <elvisdman@hotmail.com>]

Here's an example I always use to round to the nearest thousand.

let #ResultRounded = 1000 * ceil(#NumberToRound / 1000)


>From: "radhika reddy" <radhika_05@hotmail.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: sqr-users@sqrug.org
>Subject: [sqr-users] rounding to thousand
>Date: Tue, 31 Jan 2006 10:05:56 -0600
>
>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