2019.2

2. Click the data field that contains the numeric value that you want to display differently, or
add the data field to the script with the Add field button on the right.
3.
Under Format choose one of the following settings:
l
Custom Pattern: allows you to enter a custom format mask. For example, the
pattern 000000 means that the number should count six digits; leading zeros are
added to numbers shorter than six digits. For an overview of pattern symbols see
"Number patterns" on page1347 and
http://docs.oracle.com/javase/7/docs/api/java/text/DecimalFormat.html. In the data
mapping configuration, set the field type to Integer, Float or Currency. When you
open a data file or database, all fields are text fields (fields of the type string).
l
Standard: displays the number with the default pattern and symbols for the current
Locale.
l
Grouped displays a number with three decimal places and sets the thousands
separator for the value based on the current locale; see "Locale" on page782.
l
Currency displays a number as an amount of money, with a thousands separator
and rounded to two decimal places, based on the current locale; see "Locale" on
page782.
l
Currency no symbol does the same as Currency, but omits the currency symbol.
l
Leading zero adds a leading zero to a floating value between 0 and 1. This format
is only available for fields that contain a float value. Note that when you open a
data file or database without a data mapping configuration, all fields are of the type
string.
l
∑ (Sum) and ∑↑ (Sum Up) are used in Detail Tables in a Print context. ∑ is for
transport rules at the end of a page and ∑↑ shows the subtotal of the previous page.
4. Close the Script Wizard. For a new script, don’t forget to add the selector to the template.
Showing content conditionally
One way to personalize content is to show or hide one or more elements depending on a field’s
value. For example, a paragraph written for Canadian customers could be hidden when the
recipient of the letter is not living in Canada, if that can be derived from the data.
The Conditional Script Wizard helps you to show or hide one element – a paragraph, image or
other HTML element - based on the value of one or more data fields. For example, you could
check whether the data field 'State' is 'Equal To' the value 'British Columbia' or 'Québec', to
include a paragraph for all recipients in those states.
Page 810