Median

 

Purpose:

Calculates the median of the set of values that result from the first parameter / formula.

Parameter:

Number       Expression for the value to be averaged.

Boolean       (optional) The values which were stored for the calculation are deleted after output. (default: TRUE). Please note that the stored calculation values are generally deleted for every (sub)table end. The second parameter only decides whether the values are already deleted within the table.

Return value:

Number

Example:

Median(UnitsInStock)