RE: [sqr-users] Arithmetic operations on Floats in SQR

["Paul Hoyte" <paul.hoyte@sharidionne.com>]

You can declare the variables that you want to use as FLOAT variables and
then use those in your program.  See the DECLARE-VARIABLE command
syntax...... 


Paul Hoyte
Sharidionne Inc.
(248) 752-6970
paul.hoyte@sharidionne.com
 

-----Original Message-----
From: sqr-users-bounces+paul.hoyte=sharidionne.com@sqrug.org
[mailto:sqr-users-bounces+paul.hoyte=sharidionne.com@sqrug.org] On Behalf Of
Kajal Somaiya
Sent: Wednesday, March 03, 2004 11:50 PM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] Arithmetic operations on Floats in SQR

Hi Chandra,
I tried doing
move &trdposition to #trdposition
which is similar to
let #trdposition = &trdposition - i hope. 
But my worry out here is that the values after the decimal will get
truncated and this will not be of any help to me, as the report expects the
data to be displayed as a float and not just integer part of the value.
Please suggest if there is some way in which the numbers can be sored as
floats in SQR and simultaneously the arithmetic operations can be carried on
them also.
regds,
kajal

------------------------------------
Xoriant Solutions Pvt Ltd.
Kajal Somaiya
Sofware Engineer
Kajal.Somaiya@xoriant.com
------------------------------------


-----Original Message-----
From: chandrashekar patlolla [mailto:chandrashekar_patlolla@yahoo.com]
Sent: Wednesday, March 03, 2004 6:58 PM
To: This list is for discussion about the SQR database reporting language
from Hyperion Solutions.
Subject: Re: [sqr-users] Arithmetic operations on Floats in SQR


May be this will help you

 
TradingPosition/1000000 &trdposition
let #trdposition = &trdposition
add #trdposition to #subtottrdposition.
 
As far as i know you have to convert it into number first and then do
arithmatic operation.
 
Chandra
Kajal Somaiya <Kajal.Somaiya@xoriant.com> wrote:
Hi All,
In one of my sqrs the code is someting like this....

TradingPosition/1000000 &trdposition
add &trdposition to #subtottrdposition

but the SQR while execution throws following error in versio 6.2 Error on
line 105:
(SQR 1400) Only numerics allowed for arithmetic.

This was working fine in version 3.0.12.x

I tried doing
move &trdposition to #trdposition
but that is like truncating the decimal part of a number.

Please suggest a work arround.
regds,
kajal

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

---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you're looking for faster.
_______________________________________________
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