[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Reg Num Formatting
- Subject: [sqr-users] Reg Num Formatting
- From: "Vaidyanathan, Ramakrishnan \(GE, Corporate,consultant\)" <ramakrishnan.vaidyanathan@ge.com>
- Date: Thu, 12 Oct 2006 09:08:21 -0400
- Delivery-date: Thu, 12 Oct 2006 09:11:33 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: Acbt/35PDLSzgjrPTb+D61MpLLhC3A==
- Thread-topic: Reg Num Formatting
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