SGN(

General Form:

     SGN(numeric_expression)

The SGN( function is used to determine the sign of the specified numeric expression. The SGN( function is valid wherever a numeric function is legal.

If the result of the expression is less then zero a value of -1 is returned. If the result is greater than zero a value of 1 is returned. If the result is zero then zero is returned.

Syntax examples:

abc = SGN(result)
Second = test * SGN(totals(count) * 10)