Number Formats allow you to define how numeric values and data should be formatted in your Column, Line and Report Definitions. Prospero provides you with several out-of-the box standard numeric formats. However, you can define and maintain your own.
To access Number Formats:
1. Click on the Configuration bar in the Prospero Navigation Pane.
2. Click
on the Number Formats icon to open the Number Formats
workspace.
3. The fields and options available include the following:
•Label – The code, or ID, which you assign or which has already been assigned to a Number Format.
•Format String – This field contains the string of characters which show how your numbers will appear in Prospero. The codes and characters you can use for defining your Format String are as follows:
o The # character is used as a placeholder for a digit in your number format. Any leading or trailing zeroes that appear in the format would be suppressed.
For example, the format string $#,### will not show zeroes in blank lines on reports where that format is used.
o The 0 character is used as a placeholder for a digit in your number format. Any leading or trailing zeroes that appear in the format would appear.
For example, the format string $#,##0 will show zeroes in blank lines on reports where that format is used.
o The parenthesis characters ( ) placed around a number format indicate how Prospero will display negative numbers. If a Format String is enclosed in ( ) negative numbers will be enclosed in parentheses by default and will not display a – sign.
o The plus sign character + will force Prospero to include a sign (positive or negative).
o Use the dot, or period (.) to indicate where Prospero should include a decimal separator. The decimal separator to use is drawn from the local computer's regional settings.
o Use the comma, to indicate that Prospero should include thousands separators in the number format. The thousands separator that is used is drawn from the local computer's regional settings.
o Use a dollar sign $ to indicate that Prospero should include a currency symbol. The currency symbol used is drawn from the local computer's regional settings.
•Positive – Provides a representation of how the number will appear in positive format.
•Negative – Provides a representation of how the number will appear in negative format.
•Zero – A visual indicator of how the number will appear in all zeroes format. If the field is blank the value will not appear with any additional formatting.
•Comment – A text box providing a location for informational or descriptive text about the Number Format.
•Inactive – When checked, this checkbox option indicates that the Number Format is inactive. That specific Number Format will no longer be selectable from your Column, Line or Report Definition Number Format fields.
Note: To manage Number Formats, you must log in to the entity using an ID with permission to maintain entities. This is an Administrative-level permission. For more information, see the section on Prospero Security Permissions in Security or contact the MSX Group.
For more information on the Number Formats, refer to the sections on the Line Number Format Field and the Column Number Format Field.