Marinko, The U2 database is an integer only system, when it comes to using the inbuilt calculations. Numbers should be normalized using the input and output conversions.
For instance, money is stored as total number of cents rather than dollars. The conversion code of MD22 will shift the decimal point two places to the left during display. Cheers, David Murray -----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/