Vector Aggregating Functions

Functions in data analysis allow the aggregation of values from compound expressions like grids or numeric lists.

There is a number of functions aggregating values of "vector" (or compound) expressions (like grids, multi variables, numeric lists, etc.). Such functions take a "vector" argument of a certain type and produce a scalar result from all values in a compound value.

Function	Argument / Result	Comment	Example
any(v)	Boolean vector (multi) / Boolean	True if at least one value in the argument is true	any(:multi) Returns ""true"" if any of the options in :multi have been selected
all(v)	Boolean vector (multi) / Boolean	True if all values in the argument are true	all(:multi) Returns ""true"" if all of the options in :multi have been selected
vcount(v)	any vector type / Integer	Number of non-null values in the argument	vcount(:text_list) Returns the number of options in the question :text_list
vselected(v)	Boolean vector (multi) / Integer	Number of selected ("true") values in a boolean vector	vselected(:multi) Returns the number of selected options in :multi for each response
vsum(v)	Numeric vector type / Source element type	Sum of non-null values in the argument	vsum(:numeric_list) Returns the sum of the non-null values in :numeric_list for each response
vaverage(v) (alias vavg(v))	Numeric vector type / Real	Average of non-null values in the argument	vavg(:numeric_list) Returns the average of the non-null values in :numeric_list for each response
vmin(v)	Comparable vector type / Source element type	Minimum of non-null values in the argument	vmin(:numeric_list) Returns the smallest value in :numeric_list for each response
vmax(v)	Comparable vector type / Source element type	Maximum of non-null values in the argument	vmax(:numeric_list) Returns the biggest value in :numeric_list for each response
vmini(v)	Comparable vector type / Category	Category code containing minimal value in the argument	vmini(:numeric_list) Returns the label of the category in the variable :numeric_list which contains the smallest value for each response
vmaxi(v)	Comparable vector type / Category	Category code containing maximal value in the argument	vmaxi(:numeric_list) Returns the label of the category in the variable :numeric_list which contains the biggest value for each response