[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: Edit Mask for '%'
Sarabudla,
Thanks, for your info.
Kishore
----------
From: Sarabudla, Raji R. [SMTP:Raji.R.Sarabudla@KP.ORG]
Sent: Thursday, July 15, 1999 2:40 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: Edit Mask for '%'
Hi Kishore,
There is no such mask or format, which can multiply with 100 and concat
with %. But you can simplify the above problem by just multiplying with 100
or using the substr & instr function. You can mask with % (Percentage sign)
using edit in print command. The following example simplifies your problem
Ex:
Let #number = 0.56
or databse column
Let $percent = #number * 100
Or
Let $percent = substr(#number,instr(#number,'.')+1,2)
Print $percent edit xx%
Hope this may help,
Raji
----------
From: *Krishna Kishore [SMTP:KKishore@SMTPGW.ARMS.OHIO-STATE.EDU]
Sent: Thursday, July 15, 1999 11:38 AM
To: Multiple recipients of list SQR-USERS
Subject: Edit Mask for '%'
I am trying to print a report, I want to show a field in percentage:
say
$percent = 0.34
in print section on the report I want it to be printed as 34%.
Print $percent ( 2,14) ?????????
I know that we can multiply with 100 and concat with '%'
Is there any mask for this.
SQRW V4.0
Any ideas would be appreciated.
Kishore.
----------