Re: [libreoffice-users] Calculations in Report Builder

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