Numeric Fields
Numeric fields are those fields containing numbers or amounts only.
Valid masks are:
MASK: | EFFECT: |
|---|---|
####### | Prints the number, do not insert commas, print only the whole number portion. Minus sign will precede number in cases of a negative number. Eg. 12345.67 Credit would print -12345 |
#,###,### | Prints number, as above and insert commas. Eg. -12,345 |
#,###,###.## | Prints as above, but include up to two decimal positions. Eg. -12,345.67 |
#,###,###.## | Prints as above, but put a minus sign following the number, if applicable. Eg. 12,345.67 |
**##,###.## | Fill unused elements of the mask with the symbol '*' Eg. ****12,345.67 |
$**#,###.## | Precede the number with a dollar sign and leading asterisks. Eg. $***12,345.67 |
$$**#,###,###.## | Print a dollar sign immediately to the left of the first significant digit. Eg. $12,345.67 |
$$<0>#,###,###.## | Print the numeric, filling the unused spaces with zeros, instead of spaces. This mask CANNOT be used in the same field as the symbol '*', or the field using <%>. Eg. $0,012,345.67 |
<%>#,###,###.## | Print this field, using spaces if the field is zero. (If the field is zero, nothing prints). Mask CANNOT be used in the same field as the symbol '*' or the field using <0>. |
<CD>$**#,###,###.## | Print the notation 'CR' after negative figures, and the notation 'DR' after positive figures. Eg. $****12,345.67CR |
XXX $**#,###.## | Where XXX represents characters to be printed before the number. (Characters preceding a mask may NOT include the special characters '-', '*', or '$'. Eg. XXX $**12,345.67 |
NOTE: In a numeric mask, each symbol represents one digit in the number to be printed. It is recommended you define the mask to be as large as the largest possible number to be printed in the field.