ArrayBuild Stmt vs. Function

Panorama X
1

FWIW, when I use them, including “” for the fourth parameter works fine with the ArrayBuild( function, but the ArrayBuild Statement returns an empty array. Both work as described with the parameter completely eliminated.

RA=arraybuild(¶,“”,{datepattern(Date,“yyyy”)},“”)
RA=arraybuild(¶,“”,{datepattern(Date,“yyyy”)})
arraybuild RA,¶,“”,datepattern(Date,“yyyy”)
arraybuild RA,¶,“”,datepattern(Date,“yyyy”),“”

Last line returns “”.

2

This is a minor bug, but it is a bug that is now fixed. It actually affects arraybuild, arrayselectedbuild, formulasum, globaldictionarybuild and superarraybuild. For now, you can either omit the parameter entirely, or use the formula true() instead of "".