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

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

Place the DECLARE-VARIABLE definition in the setup section and that will get
rid of the errors. 


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: Thursday, March 04, 2004 2:21 AM
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 Paul,
I tried doing the following
DECLARE-VARIABLE
DEFAULT-NUMERIC=FLOAT
FLOAT #trdposition
END-DECLARE

and moved the value like this
move &trdposition to #trdposition

But i get the following error now
Error on line 47:
   (SQR 4702) Line found outside paragraph.
DECLARE-VARIABLE

Error on line 48:
   (SQR 4702) Line found outside paragraph.
DEFAULT-NUMERIC=FLOAT

Error on line 49:
   (SQR 4702) Line found outside paragraph.
FLOAT #trdposition

Error on line 50:
   (SQR 4702) Line found outside paragraph.
END-DECLARE

I am using sqr 6.2

Please suggest....

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


-----Original Message-----
From: Paul Hoyte [mailto:paul.hoyte@sharidionne.com]
Sent: Thursday, March 04, 2004 11:00 AM
To: 'This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.'
Subject: RE: [sqr-users] Arithmetic operations on Floats in SQR


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

_______________________________________________
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