ARRAY

This function returns an array that contains a parameter value for each detailed record. If the expression specified in the parameter contains the Array function, this expression is considered an aggregate expression. The function parameter can have an arbitrary type.

You can use an expression that returns a value table as a parameter. In this case, the Array function returns an array that contains values from the first column of the value table.

ARRAY(OfferCount)