Thanks Alex. The underlying query gets the month from the date, as well as the total, average, max and min for each month. The results are, of course, already grouped & calculated by month. I was able to get the overall total, but also wanted to see the overall average, max and min. I somehow imagined that it would be a piece of cake. It looks like Calc is the better "report tool" in this case.
In Calc, I dragged the query into a spreadsheet, and simply created a series of formulas to perform the calculations on the results. If I alter the query, how can I get the overall average, apart from the monthly averages? Thanks, Don On Fri, Sep 26, 2014 at 3:45 AM, Alex Thurgood <[email protected]> wrote: > Le 25/09/2014 23:59, Don Parris a écrit : > > > Hi Don, > > > shown, and that works great. I used the "Accumulation" function to do > > this. But when I try to get an overall average, I wind up getting the > > average for the first month (in the report), not for the year-to-date. > > > > What expression are you using in the definition of your Report Builder > field to obtain the average of all months combined ? If you just use > something like AVG[MONTH] then it will only average on that particular > month. > > It might be better, as Tom has suggested, to create a separate result in > your initial query in order to provide the average of the combined > months rainfall. > > > Alex > > > > -- > 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 > -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ <https://www.xing.com/profile/Don_Parris> <http://www.linkedin.com/in/dcparris> GPG Key ID: F5E179BE -- 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
