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
• field1 mask “#####.##” — prints as above without any comma separators.
  • 1234.56499 prints    1234.54
• 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).
• 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”).
• field1 mask “$##,###.##” — value rounded to two decimal places with a dollar sign.
  • 12345.67 prints    $12,345.67
  • -12345.67 prints    $-12,345.67
• 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)
• field1 mask “$  ##,##.##” — the dollar sign can be padded with additional spaces
  • 12345.67 prints    $  12,345.67
• field1 mask “$  (##,###.##”
  • -12345.67 prints    $  (12,345.67)

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 >