Aggregate Functions The aggregate functions SUM and AVG can be applied to a series of vectors dimension-wise. AVG The AVG function takes a vector expression as input and returns the average as a vector with format FLOAT64. SUM The SUM function takes a vector expression as input and returns the sum as a vector with format FLOAT64.