Using Sections In a Numeric Format
A numeric format can include up to four sections. A semicolon (;) separates each section. The format varies depending on the number of sections you specify:
One section. This section applies to every value.
- Two sections:
The first section applies to positive values and zeros.
The second section applies to negative values.
- Three sections:
The first section applies to positive values.
The second section applies to negative values.
The third section applies to zeros.
If you include semicolons with nothing between them, then Siebel VB uses the format of the first section to print the undefined section.
Four sections. Same as three sections, except the fourth section applies to Null values. If you do not include the fourth section, and if the input expression results in a NULL value, then Siebel VB returns an empty string.
The following table includes examples of using sections.
| Number | Format | Result |
|---|---|---|
1234567.89 |
#,0.00;(#,0.00);"Zero";"NA" |
1,234,567.89 |
-1234567.89 |
#,0.00;(#,0.00);"Zero";"NA" |
(1,234,567.89) |
0.0 |
#,0.00;(#,0.00);"Zero";"NA#" |
Zero |
0.0 |
#,0.00;(#,0.00);;"NA" |
0.00 |
Null |
#,0.00;(#,0.00);"Zero";"NA" |
NA |
Null |
"The value is: " |
0.00 |