Appendix A: Statistical Formula Definition

Parameter	Possible Value
formula	<aggregate>
aggregate	<aggr_boolean> ? <aggregate> : <aggregate> <aggregate> ^ <aggregate> <aggregate> % <aggregate> <aggregate> + <aggregate> <aggregate> - <aggregate> <aggregate> * <aggregate> <aggregate> / <aggregate> - <aggregate> ( <aggregate> ) <system_proc1> ( <aggregate> ) <system_proc2> ( <aggregate> , <aggregate> ) greatest ( <aggregate_list> ) least ( <aggregate_list> ) <aggregate_func> ( <action_types_list> ; <number> ; <condition> ) <aggregate_func> ( <action_types_list> ; <number> ) COUNT ( <action_types_list> ; <condition> ) COUNT ( <action_types_list> ) @COUNT ( <action_types_list> ; <condition> ) @COUNT ( <action_types_list> ) <float literal> * <int literal> * <sys_var>
aggr_boolean	<aggr_boolean> & <aggr_boolean> <aggr_boolean> | <aggr_boolean> ~ <aggr_boolean> ( <aggr_boolean> ) <aggregate> = <aggregate> <aggregate> != <aggregate> <aggregate> < <aggregate> <aggregate> <= <aggregate> <aggregate> > <aggregate> <aggregate> >= <aggregate>
aggregate_list	<aggregate> <aggregate> , <aggregate_list>
action_operand	<action type> ~ <action_type> *
action_types_list	<action_operand> <action_types_list> , <action_operand>
condition	<boolean>
boolean	<boolean> & <boolean> <boolean> | <boolean> ~ <boolean> ( <boolean> ) <kv_boolean> <number> = <number> <number> != <number> <number> < <number> <number> <= <number> <number> > <number> <number> >= <number> <string> = <string> <string> != <string> rank_lt ( <number> , <int literal> ) rank_gt ( <number> , <int literal> )
number	<boolean> ? <number> : <number> greatest ( <number>_list ) least ( <number>_list ) <number> ^ <number> <number> % <number> <number> + <number> <number> - <number> <number> * <number> <number> / <number> - <number> ( <number> ) <system_proc1> ( <number> ) <system_proc2> ( <number> , <number> ) <num_attr> <kv_number> <float literal> <int literal> convert ( <string> ) <sys_var>
number_list	<number> <number> , <number_list>
num_attr	duration start end
string	<string> + <string> <kv_string> sub ( <string> , <int literal> , <int literal> ) upper ( <string> ) lower ( <string> ) <string_literal>
kv_string	kvstr ( <kv_attrib> , <string> ) kvstr ( <kv_attrib> , <string> , <int> )
kv_number	kvnum ( <kv_attrib> , <string> , <int> ) kvnum ( <kv_attrib> , <string> ) kvsum ( <kv_attrib> , <string> ) kvmin ( <kv_attrib> , <string> ) kvmax ( <kv_attrib> , <string> ) kvavg ( <kv_attrib> , <string> )
kv_boolean	kvexists ( <kv_attrib> , <string> , <string> )
kv_attrib	<kv_atomic_attrib> kvlist ( <kv_attrib> , <string> ) kvlist ( <kv_attrib> , <string> , <int> )
kv_atomic_attrib	udata global_udata reasons extensions system
int	<int literal> - <int literal>
system_proc1	log exp sqrt sin cos abs ceil floor
system_proc2	pow
aggregate_func	SUM MAX MIN AVG @SUM @MAX @MIN @AVG
sys_var	$istart