Brian, Thanks for the help.
Yes, thats the dilemma, applying a mask that holds true for all the currencies, when some have no decimals. The MD20 does seem to help the original issue, with the data I have, mostly USD and GBP. I'll have to try it against Yen. The Sub-Total is actually most valuable, from the accounting perspective, and what I'm most troubled for. Believe it or not, our people actually look at the grand-total too, just to check it against some Screens that provide sales by currency and do the same combining of spinach and berries. [I guess this confirms that accountants also employ Art and emotion, not just skill; just like programmers 8-) ]. -Baker -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Wednesday, February 06, 2008 3:44 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Totaling 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/