mean
Description
Calculates the mean (a.k.a average) for the numbers in the given column of the given dataset or the mean of a series of numbers specified as arguments. When looking up the mean in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored. If there are no rows in the dataset, zero is returned.
Syntax
mean(dataset, column OR number, number...)
Examples
For example, suppose you had a table with this dataset in it:
ProductCode |
Quantity |
Weight |
BAN_002 |
380 |
3.243 |
BAN_010 |
120 |
9.928 |
APL_000 |
125 |
1.287 |
FWL_220 |
322 |
7.889 |
mean({Root Container.Table.data},
"Weight"
)
//... would return 5.58675
mean(
1
,
2
,
3
)
//... would return 2