[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Reg Num Formatting
- Subject: Re: [sqr-users] Reg Num Formatting
- From: "Larry Roux" <LRoux@syr.edu>
- Date: Thu, 12 Oct 2006 09:16:39 -0400
- Delivery-date: Thu, 12 Oct 2006 09:19:05 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
An easy ( and perhaps not the most elegant) way is:
Let #tempvar = ''00728436'
Let #tempvar = #tempvar * .01
Let $outvar = edit(#tempvar,'999999.99')
Larry Roux
Information Systems
Syracuse University
lroux@syr.edu
>>> ramakrishnan.vaidyanathan@ge.com 10/12/2006 9:08 AM >>>
Hi All,
I have a file that has the amounts displayed in the Mainframe
format i.e it has A's, B's, { etc signs to display the numbers. I have
converted it into appropriate number values. For eg the result that i
get after conversion is 00728436. I want it to be displayed as 7284.36.
Total length of the field is 8 (6.2) (6 real no and 2 decvimal point.)
Is there any edit mask to accomplish this.
Thanks in advance
Ram
_______________________________________________
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