This function gets the mean value for values other than NULL. You can use a result of the Array function as a parameter.

AVG(Balances.Quantity)