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])