Numeric Format Properties

Formatting options for the selected numeric column(s), variable(s), or calculated field(s).

To apply formatting options to more than one numeric column, variable, or calculated field, press [Shift] and click the desired objects in the layout.

To apply formatting options to all the numeric columns, variables, and calculated fields in one layout section, click in the section and select Edit, then Select All.

Property	Description
Format	User defined—Define the information on the property page. NUMBER-EDIT-MASK—Uses the numeric settings in the [local...] section of SQR.INI. If selected, all other options are disabled. MONEY-EDIT-MASK—Uses the currency settings defined in the [local...] section of SQR.INI. If selected, all other options are disabled. For more information on defining EDIT-MASK settings in SQR.INI, see Volume 2 of the Hyperion SQR Production Reporting Developer's Guide.
Width	Number of digits to the left and right of the decimal point.
Alignment	Left or Right alignment.
Money Sign	None—Does not print the currency symbolt. Float—Moves currency symbols with numbers. For example: $13,648 $32 $447 Fixed—Aligns currency symbols. For example, Right Alignment with a Fixed Money Sign, right-aligns the numbers but keeps the currency symbols fixed. $13,648 $ 32 $ 447
Separator	Imply decimal points—Does not print decimal points. For example, 106.00 would print as 10600. Delimit thousands—Delimits thousands commas. For example, 41200066 would print as 41,200,066. (To delimit thousands with delimit points, use the Special option, described below.)
Fill	None—No special fill attributes. Zero Fill to Left—Prints zeroes to the left of the number: 13,648 000032 000447 Show Blank if a Value is Zero—Prints a blank instead of a zero..
Special	None—Indicates that you do not want any of the special options listed below. Use scientific format-Used for very small or very large numbers. For example: 1.02e+08 = 102,000,000 1.02e-08 = 0.0000000102 Show N/A if a column is null—If a column contains no data, print N/A. Show blank if a column is null—If a column contains no data, leave it blank. Delimit thousands with periods and decimals with commas—Prints numbers as follows: 1.045,34 Show a minus at the right of a negative number—Prinst negative numbers as follows: 684- Show angle brackets around a negative number—Prints negative numbers as follows: <684> Show parentheses around a negative number—Prints negative numbers as follows: ( 684) Show floating parentheses around a negative number—Prints negative numbers as follows: (684) (349024)
Alias	Alternate column name. For example, an alias for Store Street Address could be stor_address. To view aliases in the report layout, select View, then Column Aliases.