Median

Description

Middle value in a set of numbers. If there is an even number of values, it is the average of the two middle values.

Calculation Editor

Options

Input Parameter Values	Input Values
Only Rollup If	Generic Criteria

Input

Input	Input Values	Required
Input 1	Column or Literal	✔
Input 2	Column or Literal

Examples

Example 1

1. Input: Quantity 1 (400), Quantity 2 (750), Quantity 3 (114)
2. Quick Calculations > Math > Median
3. Output: 400

Example 2

1. Input: Amount 1 (15), Amount 2 (7), Amount 3 (19), Amount 4 (3)
2. Quick Calculations > Math > Median
3. Output: 11
   1. Reasoning: Even number of values result in the average of the two middle values : 15 and 7