Re: [libreoffice-users] Calculations in Report Builder

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


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