Reactor

Statistic Functions

Mappings: Functions and Expressions · Updated June 9, 2025

Average and Avg

Description

  1. Returns the numerical average value in a dataset, ignoring text.

ℹ️ AVERAGE and AVG are synonymous and can be used interchangeably

Syntax

AVERAGE(value1, [value2, ...]) or AVG(value1, [value2, ...])

Examples

  1. AVERAGE(2,2) returns 2

  2. AVG(2,4,6,8) returns 5

Maximum

Description

  1. Returns the maximum value in a numeric dataset.

Syntax

MAX(value1, [value2, ...])

Examples

  1. MAX(3,6,-9) returns 6

Minimum

Description

  1. Returns the minimum value in a numeric dataset.

Syntax

MIN(value1, [value2, ...])

Examples

  1. MIN(3,6,-9) returns -9