Decimal masks
In addition to the “#” placeholder, the “0” (zero) is used with decimal numeric values. The zero is valid only in the decimal portion of the mask (to the right of the decimal point).
- field1 mask “##,###.##” — prints the value rounded to two decimal places.
- 1234.560 prints
1,234.56
- 1234.565 prints
1,234.57
- 1234.560 prints
- field1 mask “#####.##” — prints as above without any comma separators.
- 1234.56499 prints
1234.54
- 1234.56499 prints
- field1 mask “##,###.00” — For each zero in the mask, if the field value resolves to zero in the rightmost position as a zero in that position, the zero value does not print. This is the method to trim a decimal value. In this case both the decimal positions are set to trim.
- 1234.50 prints
1,234.5
- 1234.56 prints
1,234.56
- 1234.06 prints
1,234.06 (the zero fails on the rightmost digit).
- 1234.00 prints
1234 (if the value resolves to zero decimal places, it prints as an integer).
- 1234.50 prints
- field1 mask “##,###.#00” — all of the values will print at least one and at most three decimal places.
- 1234.567 prints
1,234.567
- 1234.001 prints
1,234.001 (the mask zero fails on the rightmost digit).
- 1234.510 prints
1,234.51
- 1234.500 prints
1,234.5
- 1234.000 prints
1,234.0 (the first decimal place on the mask is a “#”, not a “0”).
- 1234.567 prints
- field1 mask “$##,###.##” — value rounded to two decimal places with a dollar sign.
- 12345.67 prints
$12,345.67
- -12345.67 prints
$-12,345.67
- 12345.67 prints
- field1 mask “$(##,###.##)” — negative values replace the minus sign with parentheses. The right parenthesis is not required.
- 12345.67 prints
$12,345.67
- -12345.67 prints
$(12,345.67)
- 12345.67 prints
- field1 mask “$ ##,##.##” — the dollar sign can be padded with additional spaces
- 12345.67 prints
$ 12,345.67
- 12345.67 prints
- field1 mask “$ (##,###.##”
- -12345.67 prints
$ (12,345.67)
- -12345.67 prints
For export, numeric and decimal value masks all translate to formats acceptable to the export type.
Page 1 — mask
Page 2 — the asterisk
Page 3 — numeric masks
Page 4 — decimal masks
Page 5 — date mask
Next – Date mask >