1.7

Boolean expressions
Boolean values can also be set using an expression of which the result is true or false. This is
done using operators and comparisons.
Example: record.fields["isCanadian"] = (extract("Country") == "CA");
For more information on JavaScript comparison and logical operators, please see
w3schools.com or developer.mozilla.org.
Currency
The Currency data type is a signed, numeric, fixed-point 64-bit number with 4decimals.Values
range from -922 337 203 685 477.5808 to 922 337 203 685 477.5808. This data type is
routinely used for financial calculations: it is as precise as integers.
Defining Currency values
l
Preprocessor:
l
In the Step properties pane, under Properties, add or select a field.
l
Specify the Type as Currency and set a default value as a number with up to 4
decimal points, followed by a semicolon; such as 546513.8798;
l
Extraction:
l
In the Data Model, select a field.
l
On the Step properties pane, under Field Definition set the Type to Currency.
l
Under Data Format, specify how the value is formatted in the data source (see
Extract Step; for the default format settings, see "Data source settings" on page92).
The field value will be extracted and treated as a Float.
l
JavaScript Expression: Set the desired value to any Float value. Example:
record.fields["PreciseTaxSubtotal"] = 27.13465;
Note
While Currency values can be set to up to 4 significant digits, only 2 are displayed on screen.
Page 143