Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


On Thu, 26 Dec 2013 21:41:48 +0100
Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:

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.

I've been playing around with column definition, increasing decimal
point in numerics and nothing changed.
I couldn't see the number of decimals increase in any step of my
computation.

It seems related to:

http://nabble.documentfoundation.org/rounding-off-number-results-in-Base-td4056773.html

that's pretty an old problem and I couldn't find any workaround.

This looks pretty critical

I'm running:
Version: 4.1.4.2
Build ID: 410m0(Build:2)
in sid



-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.