ct4.us

Calculates the average value of all the records that match the filter.

Basic usage:

{{ record.avg }}

Usage with parameters:

{{ record.avg(Table, Value Field, Filter) }}

Parameters:

1. Table (optional) – The name of the Table to count records from.
2. Value Field (optional) – The field to read the value from.
3. Filter (optional) – Optional filter, ie. fieldname=some value.

Example:

{{ record.avg("products","price") }}