This is a problem that leads me to think I must be making a mistake, but I can’t find one. These two versions of arraybuild( result in substantially different results, but they should be identical, I think:
Many more rows are included in the second array. (121 rows vs 89 rows in my database).
But if I simply do a selection with those two formulas, the both return 89 rows. So it seems like emptycell( is not working correctly when used inside the query of an array build function.