Redigera

Dela via

sign()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Returns the sign of the numeric expression.

Syntax

sign(number)

Learn more about syntax conventions.

Parameters

Name Type Required Description
number real ✔️ The number for which to return the sign.

Returns

The positive (+1), zero (0), or negative (-1) sign of the specified expression.

Examples

Run the query

print s1 = sign(-42), s2 = sign(0), s3 = sign(11.2)

Output

s1 s2 s3
-1 0 1