It would be useful to be able to use a whole column as an array to use for Numeric functions. For example I could use a formula that shows how much variance there was in a number field from the Average, Max or Min of that field.

Basically it would be the same functionality that is in the Summary Bar, but available in functions.