[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.

----------