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 <[email protected]> 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: [email protected] > 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: [email protected] 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
