2013 Archives by date, by thread · List index

# Re: [SOLVED] [libreoffice-users] rounding problem with Base

```Hi :)
Are you saying you have solved this problem yourself without help from
the list or has the problem just changed a bit?
Regards from
Tom :)

On 27 December 2013 13:02, Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:
```
```On Fri, 27 Dec 2013 01:30:27 +0100
Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:

It seems I just had to adjust the format of the column of the query
once the query is run.
Right click on the query result column and chose format.

```
```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

```
```
--
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.