[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Arithmetic operations on Floats in SQR
- Subject: Re: [sqr-users] Arithmetic operations on Floats in SQR
- From: aravind kumar <a_ragz@yahoo.com>
- Date: Thu, 4 Mar 2004 01:05:38 -0800 (PST)
- Delivery-date: Thu, 04 Mar 2004 04:07:09 -0500
- In-reply-to: <2F402DB12BB6D4119C3E009027E349CE02898844@asia.bic.xoriant.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
hi,
move that &trdposition value to a numeric variable
coz column variables cannot be used in arithmetic
operations. move that variable to numeric variable and
then add it
TradingPosition/1000000 &trdposition
move &trdposition to #xyz
add #xyz to #subtottrdposition
this one works.
Aravind.
--- 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
http://search.yahoo.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users