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

[Kajal Somaiya <Kajal.Somaiya@xoriant.com>]

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