First, what are the INTERNAL values of the fields when you look at them in the editor?
Are they 12345, 56789, and 98765? Does the field have a conversion of MD2 or MR22? Second, if they are not, are they something weird like 12345.1, 56789.9, 98765.2? Your conversion code may be hiding fractional amounts on display that would still affect the calculation. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Babic Marinko Sent: Thursday, March 15, 2007 8:45 AM To: u2-users@listserver.u2ug.org Subject: [U2] SQL SUM Function Hello I have a single value field EX.NUMBER with the following values: Key EX.NUMBER A 123.45 B 567.89 C 987.65 The result of the following SQL Statement using BCI (UniVerse BASIC SQL Client Interface) is SELECT SUM(EX.NUMBER) FROM YYEXAMPLE USING DICT DYYEXAMPLE; Result: 1679 The result should be 1678.99. The statement PRECISION 4 does not affect the result. Any idea? Kind regards, Marinko ------- 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/