Example Calculating Column Totals

The following example shows how to configure a column to calculate and display the column total.

XYZ Corporation uses a request for creating and tracking employee equipment orders. XYZ has included a table component field on their request type for gathering the order information. Employees specify the Purchase Items and Cost for each item. The table component automatically calculates the total cost for the Cost column.

XYZ creates a validation with the following settings:

  • Component Type = Table Component

  • Column 1 = Purchase Item of Validation text field

  • Column 2 = Cost of Validation number

  • In the Field window for the Cost column, Display Total = Yes

The Display Total field is only enabled if the field's validation is a number.

XYZ Corporation adds a field to their Order request type that uses this validation. If a user creates a request of that type, he can click the table component icon next to the field to open the order form. The total for the Cost column is displayed at the bottom of the table.

Figure 5-9. Sample table component displaying a column total