Show/Hide All

 Overview

You can create calculated fields to add to the Data View grid. Calculated fields are expressions that can be based on fields, driver functions, or constant values.

To create a calculated field

1. Select Business Insights Explorer menu, and then select a view.

2. In the Business Insights Explorer window, select Edit menu > Column Settings. Click Calculated to create a new field.

3. In the Calculated Field window, in the Expression field, type the name of the Expression. For more information, see Calculated Field – Fields.

4. In the Expression Builder field, construct the expression by selecting a field, function, or constant from the tree in the lower section of the window and then clicking the appropriate operand button.

5. Click OK.
   
   Note You can also delete the calculated field that you created by selecting it in the Columns list in the Column Settings window and clicking Delete.

A calculated field is created.

 Example - Construct an Expression

To create an expression that joins AddressLine1 with AddressLine2, you would perform the following steps:

1. In the Calculated Field window, expand the Tables item in the tree located in the lower left section of the window, and then click AR_Customer. The fields for AR_Customer appear in the lower right section of the window.

2. Double-click the AddressLine1 field. “AR_Customer”.”AddressLine1” appears in the Expression Builder field.

3. Click the + operand button. A plus sign (+) appears after the AddressLine1 text in the expression.

4. Double-click AddressLine2 in the lower right section of the window.

5. The expression in the Expression Builder field should now look like the following:
   
   "AR_Customer"."AddressLine1"+"AR_Customer"."AddressLine2"

6. Click OK.