sign

Returns the sign of a numeric value: -1 for negative, 0 for zero, 1 for positive.

Spec

sign(arg0)

Parameters

arg0 - A numeric value.

Return Value

An int64: -1, 0, or 1.

Example

datatable(val:double)[-5.0, 0.0, 3.14]
| extend result = sign(val)

val	result
-5.0	-1
0.0	0
3.14	1