Re: [libreoffice-users] Calculations in Report Builder

Hi Keith,

You'll hate this, but WJFFM.

I unzipped your upload, opened it (and amended the connection details),
edited the report, and saw the field you were referring to. In the "Data
Field" I saw the value was
"=[AccumulationLOWReport]/[RecordCounter]" (without the quotes, of
course). When I ran this, I got the zero as you reported, and as
expected. So I removed the "=" from the "Data Field", so that it now
shows "[AccumulationLOWReport]/[RecordCounter]" (without the quotes, of
course), selected another field (you seem to need to do this before
running the report so that it updates the field, otherwise it still
runs with the old formula), ran the report, and got an average of
16.655. Which is what you want, I think?

If this doesn't work for you, then I have no idea what is wrong.

I'm running LO 4.1.1.2 on Windows 7 64 bit.

Hope you figure it out.

Paul



On Wed, 04 Dec 2013 09:53:53 +1100
Keith Bates <keith@new-life.org.au> wrote:

> Hi Tom
>
> I changed the display to 3 decimal places and it still comes out as
> 0.000
>
> When I put the individual fields into the footer they report
> correctly, but trying to do operations with them seems to not work.
>
> I have now tried every combination of quote marks including no
> quotes, and putting an = before the formula but it just returns 0 (or
> 0.000)
>
> I've uploaded the database file to dropbox if anyone would like to
> look at it https://www.dropbox.com/s/w26g98jn58f74n0/Weather.tar.gz
>
> Thanks
>
> Keith
>
> On 04/12/13 02:42, Tom Davies wrote:
> > Hi :)
> > Is it possible to see a lot more decimal places after the point?
> > Like 0.000??
> > or do ' [AccumulationLOWReport]'*1000/'[Rec
> > ordCounter]'
> >
> > Can you temporarily have the 2 fields reporting separately in the
> > header/footer to check that they are giving sensible results in
> > there? Regards from
> > Tom :)
> >
> >
> >
> >
> >
> > On 3 December 2013 10:01, Keith Bates <keith@new-life.org.au> wrote:
> > > I am going crazy over a calculation I am trying to do in Report
> > > Builder.
> > >
> > > I have a database that records weather details each day. I want to
> > > calculate average temperatures and the like, and put this into the
> > > footer.
> > >
> > > The function RecordCounter counts records correctly. The function
> > > AccumulationLOWreport sums the daily minimum temperatures. This
> > > seems to work correctly in that I can put this in the footer and
> > > get the sum of temperatures.
> > >
> > > To work out the average, I put a field in the footer. In the
> > > "Data" tab I choose "Field or Formula" and enter
> > > [AccumulationLOWReport]/[RecordCounter] . When I run the report it
> > > returns 0.
> > >
> > > I have tried all of the following, with the same result
> > > ' [AccumulationLOWReport]/[RecordCounter]'
> > > ' [AccumulationLOWReport]'/'[RecordCounter]'
> > > = [AccumulationLOWReport]/[RecordCounter]
> > >
> > > Can someone please tell me what I am doing wrong?
> > >
> > > --
> > > God bless you
> > > Keith Bates
> > > 4 Mooloobar St
> > > Narrabri NSW
> > > Ph 02 67924890
> > >
> > > Jesus is the Way
> > > the Truth and the Life
> > >
> > >
> > > --
> > > 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