Table of Contents

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