round(val: numeric, [precision: const int64]?) -> float64

Rounds numeric val to the nearest representable value at a configurable decimal scale. By default the value is rounded to an integer int64; with a positive precision constant the result is a float64 with that many fractional digits. A null val propagates as null. Related helpers floor and ceil use the same optional precision argument.

The precision argument is an optional compile-time constant in [-18, 18] that defaults to 0. Values <= 0 yield an int64 result; values > 0 yield a float64 at the requested decimal precision.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Numeric

Examples

Scales an error rate to percentage points then rounds to two fractional digits for stable dashboard display.

Uses default precision so each score snaps to the nearest integer as an int64-friendly label.