Skip to main content
Version: I2023.1.0

Sign

Syntax​

Sign(Numeric_Expression)

Input Parameters​

Numeric_Expression
A valid numeric expression, such as a numeric Measure reference or a numeric literal.

Return Value​

Returns 1.0 if the argument is positive, returns -1.0 if the argument is negative, returns 0 when the argument evaluates to 0.

Examples​

Return the sign of the Sales Amount.

Sign([Measures].[Internet Sales Amount Local])