### Average (fld), Average (fld, condFld), Average (fld, condFld, cond), Average (x)

Basic and Crystal syntax.

##### Arguments

- fld is any valid database or formula field that can be evaluated by the function.
- condFld is a field used to group the values in fld by.
- cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime or Boolean field. For more information on the valid strings for this argument, see Conditions for summary functions.
- x is an array of values that can be evaluated by the function being used.

##### Returns

Fractional Number

##### Action

Enables you to average the values that appear in your report. For example:

- If a sales report includes a field that shows the amount of each order, you can compute the average of all the orders that appear on the report (a grand total average). For information on this kind of summary, see SummaryFunction (fld).
- If you break orders into groups (for example, orders grouped by the state that they come from), you can compute the average order per group (in this case, per state). For information on this kind of summary, see SummaryFunction (fld, condFld).
- If you break orders into date or Boolean groups (for example, orders grouped by the month in which they were placed), you can compute the average order per group based on a particular change in the date or Boolean field (in this case, per month). For information on this kind of summary, see SummaryFunction (fld, condFld, cond).
- If you specify an array of individual values, you can also compute the average value in the set. For information on this kind of summary, see Array summary functions (x).

##### Examples

The following examples are applicable to both Basic and Crystal syntax:

`Average({orders.ORDER AMOUNT})`

Calculates the average of all values in the Amount field.

`Average ({orders.ORDER AMOUNT}, {customer.CUSTOMER ID})`

Finds the average amount of a sale made to each customer.

The following example is applicable to Crystal syntax:

`Average ([10,12,32,48])`

Calculates the average of the values in an array of constants.

Note: Using this function in a formula forces the formula to be evaluated at print time. For more information on evaluation time considerations, see Evaluation Time functions.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com