Description:
I have this function on my sheet:

SORT(FILTER(CHOOSE({1.2};$'Master log of records'.$B$5:$B$10033;$'Master log of records'.$A$5:$A$10033);$'Master log of records'.$B$5:$B$10033=B29;"NULL");2;-1)

It works fine, when FILTER results in at least two and more rows, but when that underlying FILTER table results in only 1 entry, it returns err504. I tested that with excel and it works fine there. It is really strange. It works normally if I use:

=CONCATENATE("QF-004-002"; " / "; RIGHT(IFNA(VLOOKUP(B30;SORT(FILTER(CHOOSE({1.2};$'Master log of records'.$B$5:$B$10045;$'Master log of records'.$A$5:$A$10045);$'Master log of records'.$B$5:$B$10045=B30;{"NULL";"NULL"});2;-1);2;FALSE());" ");3))

i.e. two-dimensional array for "result if empty" parameter.

version 24.8.2.1

Thanks a lot.

Steps to Reproduce:
Please, use the complex function described in description section. See attached file.

Actual Results:
err504 with that function. I will attach file for ease of testing as it is difficult to describe input and results.

Expected Results:
I expect not err504, but correctly formatted string.


Reproducible: Always


User Profile Reset: No

Additional Info:
I have attached the file. First sheet, first column, you can see variable results of this evaluation.
Regarding attached file: Idea is to display on first sheet, first column: document_number / last_number_used, i.e. like QF-004-001 / 002. That simply means that QF-004-001 is just a number of template and all derivatives are numbered with suffix like QF-004-001-001, QF-004-001-002 etc. Second sheet has all them (derivatives) listed. So I would like to have last no used on the first sheet next to the base document name. I do that by concatenating multiple strings of document number itself and then doing filtered (with swapped columns), sorted vlookup. This result is used with right function to get required symbols, i.e. end number of document.

Forum suggested answer here: https://ask.libreoffice.org/t/sort-function-breaks-and-shows-err504-with-a-single-row-as-a-result/112713