RE: [sqr-users] INTEGER Value

[James Womeldorf <jwomeldo@fastenal.com>]

If you REALLY want to use integers you can use 

DECLARE-VARIABLE
    INTEGER #MY_INTEGER
END-DECLARE

But be advised that assignments will result in truncated values.
E.g.

LET #MY_INTEGER = 1.23
results in 1

LET #MY_INTEGER = 1.53
results in 1

LET #MY_INTEGER = 1.5
results in 1

LET #MY_INTEGER = 2.5
results in 2

Jim

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
Bob Stone
Sent: Friday, September 24, 2004 10:15 AM
To: 'This list is for discussion about the SQR database reporting
language from Hyperion Solutions.'
Subject: RE: [sqr-users] INTEGER Value


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

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users