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.

Related Topics

Query Builder Overview



What's New in this Release


For a list of new features, see the What's New In This Release topic.

Contact us:

This documentation was developed by Infor CRM User Assistance. For content revisions, questions, or comments, contact the Infor CRM writers at documentation@infor.com.