Formualizer Docs
ReferenceFunctionsDatabase Functions

DSTDEVP

DSTDEVP: Returns the population standard deviation of a database field for matching records.

Summary

DSTDEVP computes standard deviation with the population denominator (n) after criteria filtering.

Remarks

  • Criteria rows are OR branches, and each row's populated criteria columns are ANDed.
  • field can be a case-insensitive header label or 1-based index; invalid lookup returns #VALUE!.
  • At least one numeric value must match criteria, otherwise the result is #DIV/0!.

Examples

Population stdev of units for East or West
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
6.796138609534093
Population stdev of widget revenue
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
16131.404843417147

FAQ

When should I prefer DSTDEVP over DSTDEV?

Use DSTDEVP when matching rows represent the full population; DSTDEV is for samples.

Runtime metadata

Category

Database

Signature

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

DSTDEV

DSTDEV: Returns the sample standard deviation of a database field for matching records.

DSUM

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhen should I prefer DSTDEVP over DSTDEV?Runtime metadata