[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] rounding to thousand
- Subject: RE: [sqr-users] rounding to thousand
- From: don.barclay@srs.gov
- Date: Tue, 31 Jan 2006 16:14:49 -0500
- Delivery-date: Tue, 31 Jan 2006 16:16:47 -0500
- In-reply-to: <BAY101-F5FAD6CE39F5B051CDC56EAC080@phx.gbl>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Except your example rounds up. There have been several solutions provided
that would work, although I haven't yet seen the simplest solution:
let #ResultRounded = 1000 * round((#NumberToRound / 1000),0)
Don
> let #ResultRounded = 1000 * ceil(#NumberToRound / 1000)
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users