MAX

Returns the maximum value from an expression.

Sample usage

MAX(Users per day)

Syntax

MAX( X )

Parameters

  • X - a numeric, date, or text field or expression.

Notes

  • X cannot be an aggregated field or the result of an aggregation function.

Examples

Example formula Input Output
MAX(Users per day)
  • 95
  • 100
  • 92
100
MAX(End date)
  • 2022-02-10
  • 2021-12-31
  • 2022-02-09
2022-02-10
MAX(Name)
  • Alex
  • Kalani
  • Yuri
Yuri