number-functions.md

March 27, 2026 ยท View on GitHub

Scope

Number filter functions available through the core query engine.

Source of truth: src/packages/core/src/query-engine/functions/number-functions.ts

Function List (23)

FunctionSignatureDescriptionExample
roundround(value, decimals?)Round to decimal places.3.14159 | round(2) -> 3.14
floorfloor(value)Round down.3.9 | floor -> 3
ceilceil(value)Round up.3.1 | ceil -> 4
absabs(value)Absolute value.-5 | abs -> 5
minmin(value, ...other)Minimum from values or array.[5,2,8] | min -> 2
maxmax(value, ...other)Maximum from values or array.[5,2,8] | max -> 8
clampclamp(value, min, max)Clamp into range.10 | clamp(0,5) -> 5
sqrtsqrt(value)Square root.16 | sqrt -> 4
powpow(value, exponent)Exponentiation.2 | pow(3) -> 8
loglog(value, base?)Logarithm (e base by default).8 | log(2) -> 3
expexp(value)Exponential.1 | exp -> 2.718...
sinsin(value)Sine (radians).0 | sin -> 0
coscos(value)Cosine (radians).0 | cos -> 1
tantan(value)Tangent (radians).0 | tan -> 0
sumsum(arrayValue)Sum numbers in array.[1,2,3] | sum -> 6
avgavg(arrayValue)Average of array values.[2,4,6] | avg -> 4
productproduct(arrayValue)Product of array values.[2,3,4] | product -> 24
signsign(value)Numeric sign -1/0/1.-7 | sign -> -1
toFixedtoFixed(value, decimals?)Format fixed-point string.3.14159 | toFixed(2) -> "3.14"
parseIntparseInt(value, radix?)Parse integer from string."101" | parseInt(2) -> 5
parseFloatparseFloat(value)Parse float from string."3.14" | parseFloat -> 3.14
isNaNisNaN(value)Check NaN after numeric coercion."abc" | isNaN -> true
isFiniteisFinite(value)Check finite number after coercion.42 | isFinite -> true

Notes

  • sum, avg, and product throw when input is not an array.
  • log throws when base is <= 0 or == 1.
  • toFixed returns a string, not a number.