[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Have a doubt in rounding
- Subject: [sqr-users] Have a doubt in rounding
- From: Kaz.Narayanan@averydennison.com
- Date: Tue, 13 Jul 2004 13:20:07 -0700
- Delivery-date: Tue, 13 Jul 2004 15:27:43 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Sensitivity:
Hi,
I am trying to edit a character filed and convert them as numbers.
Even thought I give 2 floating points, I still get 5 floating points.
Given below is an example:
let $RMR04 = $input_file
show 'The Last RMR filed is ' $RMR04
let #RMR04 = to_number($RMR04)
let #RMR04 = round(#RMR04 ,2)
SHOW 'tHE RMR AFTER ROUNDING ' #RMR04
Even though I have rounded my numeric variable in 2 digits, the show
statement returns 5 digits.
Please let me know If I am making a mistake.
Regards
KM Narayanan
-----------------------------------------
The information transmitted is intended only for the person or entity
to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the
sender and delete the material from any computer.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users