Nonstandard Numeric Sign Conventions

The Sign expression is used to manage nonstandard numeric sign conventions. Oracle Hyperion Financial Data Quality Management, Enterprise Edition interprets numbers with leading and trailing minus signs and numbers within parentheses as negative numbers. You can also use other leading and trailing characters to indicate negative numbers. To define custom signs, use expressions that follow this form: Sign=[Positive String],[Negative String].

For example, if positive numbers are followed by DR (1,000.00DR), and negative numbers are followed by CR (1,000.00CR), the expression is Sign=DR,CR.

Numbers within <> are also treated as negative. For example, if you specify (100.00) and <100.00> both are treated as negative numbers.

If positive numbers are unsigned ( 1,000.00), and negative numbers are followed by CR (1,000.00CR), the expression is Sign=,CR.