Apache OpenOffice (AOO) Bugzilla – Issue 16761
If both SUM and COUNT, no Grand Total on COUNT
Last modified: 2010-11-10 16:48:12 UTC
Set up a database with at least 3 columns. In Data>Subtotals define group 1 to be the SUM of a column, while group 2 is the COUNT of the column. Both groups are on the same field. In addition to the group SUMs and COUNTs, you get a SUM Grand Total, but the COUNT Grand Total is missing. Supposedly Excel supplies one.
Something that may be related: add a 3rd group (still grouped on same field as groups 1 and 2) and ask for Average. Excel will produce an average (mean) for each grouping, but no "Grand Total" average of all the data.
Please Attach the documents which make this problem, so we can test it. (Without the documents, we cannot confirm the problem easily) Don't forget to cut other part of the documents, so the file size is small, but we still able to see the problem.
This issue was very much like 19290, which has been accepted as an RFE for OOo 2.0, so closing this one. *** This issue has been marked as a duplicate of 19290 ***
closed because duplicate
Created attachment 73293