SmartList Builder 2018

Adding Calculated Fields

You can use the Calculated Fields window to add calculated fields to an Excel Report.

To add a calculated field:

1.	Click the Calculations button to open the Calculated Fields window. This window displays a list of all calculated fields created for the Excel Report.

ERB Calculated Field

2.	Click the Add button to the right of the Calculated Fields list to open the Add Calculated Field window.

ERB Calculation Syntax

3.	Enter the field name of the calculated field. This is the name of the field that will be displayed in the Excel Report.

4.	Select the field type.

Enter the script for the calculation. Add fields to the Excel Report by double-clicking on a field from the Fields list. Add functions to the Excel Report by double-clicking on a function from the Functions list. The Functions list is displayed by selecting Functions from the View button above the Fields list.

6.	Click Save.