RE: [U2] Totaling an Oconv'd DICT column

2008-02-06 Thread Brian Leach
Baker It's clearly giving floating point maths errors, but if scaled back would the figures be correct? i.e. you could add an extra MD20 conversion in field 3 of AR.TOT.USD.FRGN (ignoring the fact that combining currencies in this way is pretty meaningless...) Brian --- u2-users mailing

RE: [U2] Totaling an Oconv'd DICT column

2008-02-06 Thread Baker Hughes
an Oconv'd DICT column Baker It's clearly giving floating point maths errors, but if scaled back would the figures be correct? i.e. you could add an extra MD20 conversion in field 3 of AR.TOT.USD.FRGN (ignoring the fact that combining currencies in this way is pretty meaningless...) Brian --- u2

RE: [U2] Totaling an Oconv'd DICT column

2008-02-06 Thread Dennis Bartlett
Regards Dennis Bartlett DB Admin/Programmer [EMAIL PROTECTED] +27-21-526 4300 (tel) +27-21-555 3970 (fax) For what it's worth, I've been known to COMO the output of a LIST statement and then run the COMO file through a program that reformats the report... some things are just not possible for

RE: [U2] Totaling an Oconv'd DICT column

2008-02-06 Thread Baker Hughes
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Wednesday, February 06, 2008 11:38 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Totaling an Oconv'd DICT column Regards Dennis Bartlett DB Admin/Programmer [EMAIL PROTECTED] +27-21-526 4300

[U2] Totaling an Oconv'd DICT column

2008-02-05 Thread Baker Hughes
Hey, UV 10.2 / PIOPEN Flavor I'm trying to resolve an erratic issue with totaling on some reports, where it runs the column out to 9 decimals. It only happens when we apply the 'MD2' conversion with an OCONV, rather than using the Conv field in the DICT item. And, it does not happen

RE: [U2] Totaling an Oconv'd DICT column

2008-02-05 Thread Jerry Banker
Both D10.OCONV and AR.TOT.USD.FRGN are using D10 which is already converted. Jerry Banker -Original Message- From: Baker Hughes [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 1:07 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Totaling an Oconv'd DICT column Hey

RE: [U2] Totaling an Oconv'd DICT column

2008-02-05 Thread Baker Hughes
] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, February 05, 2008 1:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Totaling an Oconv'd DICT column Both D10.OCONV and AR.TOT.USD.FRGN are using D10 which is already converted. Jerry Banker --- u2-users mailing list