[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] INTEGER Value
- Subject: RE: [sqr-users] INTEGER Value
- From: Bob Stone <bstone@fastenal.com>
- Date: Fri, 24 Sep 2004 10:15:10 -0500
- Delivery-date: Fri, 24 Sep 2004 10:16:25 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
the # variables are the numbers, but not necesarily integers. If you want
to be sure that you get the integer value of something you could round it or
truncate it to 0 decimal places.
Let #intval = ROUND(#number,0)
Let #intval = TRUNC(#number,0)
it just depends on which integer you want to go to (trunc always rounds down
4.9 = 4, round rounds).
-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Ashish Bhatt
Sent: Friday, September 24, 2004 9:46 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] INTEGER Value
Hi SQR Gurus,
I hope you are doing fine today.
Please let me know what is the best way to get the INTEGER value in a SQR.
Please reply ASAP.
Thanks in advance.
Have a nice day and great weekend.
Regards.
Ashish Bhatt.
_________________________________________________________________
Keep track of Singapore & Malaysia stock prices.
http://www.msn.com.sg/money/
_______________________________________________
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