math.arrayMedian

math.arrayMedian() Function

• Introduced in version 1.7

Calculates the Median of the contents of a JSON Array. The median value is is the value where half the numbers in the array are greater than or equal to it, and the other half are less than or equal to it. The median is calculated by sorting the array contents and picking the middle number if the number of elements is odd, or averaging the two in the middle if the number of elements is even. Only allows numeric elements - any non-numeric values will produce an error.

Usage

[h: result = math.arrayMedian(array)]

Examples

[h: array1 = json.append("", 3, 6, 2, 2)]
[r: math.arrayMedian(array1)]
[h: array2 = json.append("", 12, 23, 3, 102, 1)]
[r: math.arrayMedian(array2)]

Returns:

 2.5
 12

math.arrayMedian