[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 the next whole number
- Subject: RE: [sqr-users] Rounding to the next whole number
- From: "Sudheer Bachu" <sbachu@creditacceptance.com>
- Date: Thu, 5 Jan 2006 13:41:21 -0500
- Delivery-date: Thu, 05 Jan 2006 13:43:09 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcYSJwUOlLfuhahLQt2HbWkfkkzjJQAAC/xQ
- Thread-topic: [sqr-users] Rounding to the next whole number
Hi murali,
You can divide the number with any number and id it is an
amount edit the number while printing like
Your_final_print_variable = edit(&calculated_number,'$$$,$$$,$$0' )
Else it is just a number then use this
PRINT $ Your_final_print_variable (0,+{col_sep},{col_amt}) edit 999
Thanks
Sudheer Bachu
-----Original Message-----
From: sqr-users-bounces+sbachu=creditacceptance.com@sqrug.org
[mailto:sqr-users-bounces+sbachu=creditacceptance.com@sqrug.org] On
Behalf Of Kaithi, Murali
Sent: Thursday, January 05, 2006 1:37 PM
To: This list is for discussion about the SQR database reporting
languagefromHyperion Solutions.
Subject: [sqr-users] Rounding to the next whole number
I have to divide a number by 10 and if the resulting number is not a
whole number, I have to Round up to the next whole number.
How can I accomplish this?
Appreciate your response.
Thanks,
Murali
________________________________________________________________________
This Email has been scanned for all viruses by PAETEC Email Scanning
Services, utilizing MessageLabs proprietary SkyScan infrastructure. For
more information on a proactive anti-virus service working around the
clock, around the globe, visit http://www.paetec.com.
________________________________________________________________________
_______________________________________________
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