I've a rounding or maybe display format problem with base.
I'm making computations with NUMERIC(30, 2)
I've a query (let's name it query1) that do some computation on numeric
columns something like:
SELECT
SUM(c1 * c2 / c3) as s1
, SUM(c4 * c5 / c6) as s2
FROM table1
GROUP BY c0;
This query actually returns several rows that have the precision I need.
Then I've query as:
SELECT SUM(s1 * s1) as ss1 from query1;
SELECT SUM(s2) as ss2 from query1;
And they return result in scientific notation with just 2 decimal
visible 6,23E+015
When I try to do further computations with ss1 and ss2 I get 0 with NO
decimal digits.
When I import query1 in localc and do the sum and squaring and
further computation there I can get the precision I need.
Thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
