[libreoffice-users] Re: Base Reports - Getting Monthly & YTD Averages

Le 26/09/2014 11:03, Don Parris a écrit :
> 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.

Having never really played around with Calc and database datasets, I
admit to not knowing, but I imagine that the function set is broader and
thus allows for more possibilities.

Would you mind posting your initial query and table definition so that I
could build my own little test db and have a think about it, otherwise
its all a bit too abstract ?

Alex


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