SIGN(n)

 

Returns a Numeric Value
Returns -1 if the number is negative. Returns 1 if the number is positive or 0.

Examples:

SIGN(TOTAL_AMOUNT)

Returns -1 if the value of the Amount Billed is -5,000.

Returns 1 if the value of the Amount Billed is 17,500.

Returns 1 if the value of the Amount Billed is 0.

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)