Floor
floor
The floor function rounds the first argument down to the nearest multiple of the second argument.
Spec
floor(arg0, roundTo)Parameters
arg0 - The numeric value to round down.
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)[12, 27, 43]
| extend floored = floor(val, 5)| val | floored |
|---|---|
| 12 | 10 |
| 27 | 25 |
| 43 | 40 |