On Fri, 27 Dec 2013 01:30:27 +0100 Ivan Sergio Borgonovo <m...@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 <m...@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+unsubscr...@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