To add a compute field

  1. In the Infor Rich Client, access the Configuration Console for Application.
  2. Select Business Classes and, if a business class configuration does not already exist for the business class you want to add a field to, select the New button at the top of the left pane and then select User Field as the configuration type in the dialog box that appears. If the business class configuration already exists, expand the business class, select User Fields, and click the Create button at the top of the left pane.
  3. Select the business class for the field, select Compute as the field type, and then click OK.
  4. Define the compute field. Consider the following fields:
    Field Name

    Enter a name for the field. It cannot begin with a lowercase letter or contain spaces. Be sure to follow your configurations naming conventions and prefix the name with a code such as ZZZ, Usr, or characters that represent your company name (for example, ACM for Acme Co).

    Default Label

    Enter the label to be used as a default for the field. You can add translated labels by clicking the globe icon and defining Locale Translations.

    Field Type, Size, Decimals

    Select the field type, and, if appropriate, enter the size and the number of decimals.

    Definition

    Create the compute statement that defines the contents of the field. Several tools or shortcuts are available to you. You can add fields from the list by dragging them or double-clicking them, you can select built-in functions for working with dates, fields, and one-to-many fields, and you can click on a set of operators to be inserted in the compute statement.

    Example 1

    This example shows a simple math computation.

    ((AgeDate - Birthdate) / 365.24)

    Example 2

    This example shows the use of the build-in "sum" function.

    (sum ActiveEmployeeWorkAssignmentsRel.PayRate)
  5. Click the Save button at the top of the right pane.

    The new compute field is now available to be added to a form configuration. You can also refer to a compute field in the definition of a derived field.