This is what I have determinied:
If 'MD2' is in the 8th field (correlatives) of the dict item PAID.AMT, I
get:
SUM DLT.DEMO PAID.AMT 12:49:20pm 26 Aug 200
DLT.DEMO...................... PAID.AMT..
==========
TOTALS 7564713.76
000039
64418 records summed.
>
If however, 'MD2' is in the 7th field (conversions) of the dict item
PAID.AMT, I get:
SUM DLT.DEMO PAID.AMT 12:50:59pm 26 Aug 20
DLT.DEMO...................... PAID.AMT..
==========
TOTALS 7564713.61
64418 records summed.
>
So the MD2 stays in the 7th field. As I said at the outset, a 'brain fart'.
Thanks for all that responded and oh by the way this occurred on a Windows
2000 server running Universe 10.0.15
Lee J Messenger
Sr VP Operations
[EMAIL PROTECTED]
DLT Transportation Services, Inc.
Phone :(816) 242-4505
Fax :(816) 483-7222
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Scott Ballinger
Sent: Thursday, August 26, 2004 11:56 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Precision question...
Take a look at that PAID.AMT dictionary item. You may want to create a
new dict item (PAID.AMT2 ?) that does an MR2 conversion.
Scott Ballinger
Pareto Corporation
Edmonds WA USA
425 670 0831
P.S. You'll get better advice if you mention your platform, release, and
account flavor. (UV or UD, etc).
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lee Messenger
Sent: Thursday, August 26, 2004 7:23 AM
To: [EMAIL PROTECTED]
Subject: [U2] Precision question...
Okay, brain fart here...
How do you control the precision used for list TOTALS and SUMS ?
SUM DLT.DEMO PAID.AMT 09:24:09am 26 Aug 2004 PAGE 1
DLT.DEMO...................... PAID.AMT..
==========
TOTALS 7564374.15
000039
62782 records summed.
>
Lee J Messenger
Sr VP Operations
[EMAIL PROTECTED]
DLT Transportation Services, Inc.
Phone :(816) 242-4505
Fax :(816) 483-7222
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
