Types of Calculated Fields

There are two types of calculations: string and numeric. When you build a calculated field using strings (alphanumeric values), you concatenate, or connect, the values together to create one value. Numeric fields cannot be used in a string. When you build a calculated field using one or more numeric fields, you perform a mathematical operation (adding, subtracting, multiplying or dividing) on the values of each field to create a new value. You can also use constants in numeric calculations. Fields that are not numeric (such as strings) cannot be used in numeric calculations.