round

The round function rounds the first argument down to the nearest multiple of the second argument. round, floor, and bin share the same rounding behavior.

Spec

round(arg0, roundTo)

Parameters

arg0 - The numeric value to round.
roundTo - The multiple to round down to. Must be arithmetically compatible with arg0.

Return Value

arg0 rounded down to the nearest multiple of roundTo. Same type as arg0.

Example

datatable(val:int)[10, 23, 47]
| extend rounded = round(val, 10)

val	rounded
10	10
23	20
47	40