Formualizer Docs
ReferenceFunctionsDatabase Functions

DMAX

DMAX: Returns the largest value in a database field for records matching criteria.

Summary

DMAX scans the filtered records and returns the maximum numeric value found in field.

Remarks

  • Criteria rows are OR conditions; multiple non-empty criteria columns in one row are AND conditions.
  • field can be a case-insensitive header string or a 1-based column index; failed resolution returns #VALUE!.
  • If no numeric values are matched, this implementation returns 0.

Examples

Maximum revenue for West or South
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
126000
Maximum units for Widget deals
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
24

FAQ

What does DMAX return when no numeric field values match criteria?

This implementation returns 0 when the filtered set has no numeric values.

Runtime metadata

Category

Database

Signature

DMAX(arg1, arg2, ... argN: Any)

This function accepts a repeating argument pattern (min args: 3).

Arity

min 3, max 1

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTION

Source

crates/formualizer-eval/src/builtins/database.rs

DGET

DGET: Returns a single field value from the only record that matches criteria.

DMIN

DMIN: Returns the smallest value in a database field for records matching criteria.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat does DMAX return when no numeric field values match criteria?Runtime metadata