Options

Calculator dialog

Fill in the following fields in the table. Entries in Field A, Field B, and/or Field C are used by the selected calculator function in the Calculation field.

Column	Description
New field	Specify the name of the field.
Calculation	When you click or press in this field, the Select the calculation type dialog box appears. Enter the calculator function to use in the transformation. A description of each function is in the Calculator Functions List. Use the Filter field to search for a specific function.
Field A, Field B, and Field C	Enter the value(s) for executing the specified calculator function in the Calculation field.
Value type	Select the field's data type from the dropdown list or enter it manually.
Length	Specify the length of the field, according to the following field types: Number: Total number of significant figures in a number. String: Total length of the string. Date: Length of printed output of the string (for example, 'four' is a length for a year).
Precision	Specify the number of floating point digits for number-type fields.
Remove	Remove this field from the result (output) after all values are calculated. This field is useful for removing temporary values. Select N or Y.
Conversion mask	Specify a format for the field, such as a date format. See Common Formats for information on common valid date formats you can use in this step.
Decimal symbol	Specify the symbol used to represent a decimal point, either a dot (.) or a comma (,). For example, 5,000.00 or 5.000,00.
Grouping symbol	Specify the method used to separate units of thousands in numbers of four digits or larger, either a dot (.) or a comma (,). For example, 5,000 or 5.000.
Currency symbol	Specify the symbol used to represent currencies, for example, $ or €.

The Calculator step also allows you to indicate if you want errors displayed for the following condition:

• Select the Throw an error on non existing files check box if you want the transformation to generate an error when there are no files to process.