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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
