Formualizer Docs
ReferenceFunctionsDatabase Functions

DVAR

DVAR: Returns the sample variance of a database field for records matching criteria.

Summary

DVAR filters records first, then computes variance using the sample denominator (n - 1).

Remarks

  • Criteria rows are OR alternatives; criteria columns within each row are AND constraints.
  • field can be resolved by case-insensitive header text or 1-based index; unresolved fields return #VALUE!.
  • At least two numeric values must match criteria, otherwise the function returns #DIV/0!.

Examples

Sample variance of units for East or West
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
61.583333333333336
Sample variance of widget revenue
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
390333333.3333333

FAQ

Does DVAR use sample or population variance math?

DVAR uses sample variance with an n-1 denominator and returns #DIV/0! when fewer than two numeric rows match.

Runtime metadata

Category

Database

Signature

DVAR(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

DSUM

DSUM: Sums values in a database field for records that match criteria.

DVARP

DVARP: Returns the population variance of a database field for records matching criteria.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes DVAR use sample or population variance math?Runtime metadata