https://bugs.documentfoundation.org/show_bug.cgi?id=171994
--- Comment #6 from ady <[email protected]> --- Well, no, you cannot use empty arrays, and that's why I am asking what is the purpose of it. So, for example, try replacing that argument with nothing (not even the argument separator) and report back: ASSEMBV( SIERREUR(FILTRE($'Résultats P6'.$B$6:$Z$23;($'Résultats P6'.$Z$6:$Z$23<>"")*($'Résultats P6'.$Z$6:$Z$23>0))); SIERREUR(FILTRE($'Résultats P5'.$B$6:$Z$23;($'Résultats P5'.$Z$6:$Z$23<>"")*($'Résultats P5'.$Z$6:$Z$23>0))); SIERREUR(FILTRE($'Résultats P4'.$B$6:$Z$23;($'Résultats P4'.$Z$6:$Z$23<>"")*($'Résultats P4'.$Z$6:$Z$23>0))); SIERREUR(FILTRE($'Résultats P3'.$B$6:$Z$23;($'Résultats P3'.$Z$6:$Z$23<>"")*($'Résultats P3'.$Z$6:$Z$23>0))); SIERREUR(FILTRE($'Résultats P2'.$B$6:$Z$23;($'Résultats P2'.$Z$6:$Z$23<>"")*($'Résultats P2'.$Z$6:$Z$23>0))); SIERREUR(FILTRE($'Résultats P1'.$B$6:$Z$23;($'Résultats P1'.$Z$6:$Z$23<>"")*($'Résultats P1'.$Z$6:$Z$23>0)))) Please note that I took ";{}" (without quotation marks) out of the formula (not just the curly brackets). This is just an example, based on what you posted. Depending on the result, the real solution could be something else, perhaps something like ";ND()" (without quotation marks), which in English would be ";NA()" (without quotation marks). Or, it might be something else. Or, there might be some bug. With the information provided, there is no way to know whether there is a bug, or instead, there is some other kind of problem. Please report back. -- You are receiving this mail because: You are the assignee for the bug.
