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