[Libreoffice-bugs] [Bug 137763] New: Aggregate(1; 6; ..) (Avg): different conditions => same value or single values and not the average

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137763

            Bug ID: 137763
           Summary: Aggregate(1;6;..) (Avg): different conditions => same
                    value or single values and not the average
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gooly at gmx.at

Description:
Enclosed is the file for the use of Aggregate.
The relevant columns are E, F ( G = combination of E & F) and the result column
T.
Black numbers are correct, red numbers are wrong. Either other conditions lead
to equal mean values (1253) - cannot be!
Or single values (T12,T13) of the result column are displayed Z12,Z13 - cannot
be either.
The solution, which shows the error division by zero (#DIV/0!) Z11 is a
proposed solution from the German forum.

I want the average of those values of the result column T for which En=Fn
applies, i.e. E="Se" && F="Se" || E="Bu" && F="Bu", therefore in Y11:
=AGGREGAT(1;6;T11:T84;(E11:E84=F11:F84)).
The rest is to test Aggregate() to understand it.

Steps to Reproduce:
1. Just look at the cells with Aggregate as described above
2. The link to download the calc file: https://we.tl/t-74RdgENvdj
3.

Actual Results:
Wrong values of AGGREGATE

Expected Results:
Correct values


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Calc. correctly.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201026/8010309c/attachment.htm>