Defining Multiple Fields in a Function

Some functions evaluate multiple fields to provide a result.  These functions may calculate the average of all values in a single column of a grid, the sum of a series of individual fields throughout the submission form, or a mix of fields and columns.

For functions that support multiple fields, a comma or Pipe character ( | ) can be used to separate the fields in the list.  Using commas is considered the best practice for legibility.

For columns in a grid, only the field names must be provided.  The system automatically retrieves all records in the grid.