ct4.us

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

Basic usage:

{{ record.joinavg }}

Usage with parameters:

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

Parameters:

1. Table (optional) – The name of the Table that has a Table Join type field.
2. Value Field (optional) – Field of joined table to read the value from.
3. Filter (optional) – Optional filter, ie. fieldname=some value.

Example:

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