Page History
Table of Contents minLevel 2 style none
AVERAGE
Use this function to determine the average (arithmetic mean) of a list or collection.
The AVG function has two syntax forms: the collection form and the list form. You can use the collection form to determine the average value of all occurrences of an attribute. The list form is used to determine the average value of a set of different attributes.
Collection form syntax
Code Block |
---|
AVG(attribute) |
- attribute - An attribute of any type of number or date of which multiple instances can occur at runtime.
List form syntax
Code Block |
---|
AVG([value1, value2, ...]) |
- [value1, value2, …] - A list of attributes, expressions or fixed values of any type of number or date. Use the square brackets to indicate that the arguments form a list of values.
Return types
- number
- integer
- currency
- percentage
- date
The function returns UNKNOWN if one or more values are UNKNOWN.
Examples
Suppose the following domain model.
Entity.attribute | Multivalued relation | Entity.attribute |
---|---|---|
Residence.appraisalValue Residence.askingPrice Residence.mortgage | hasBiddings | Bidding.amount |
If you want to determine the average bidding on the current residence:
- AVG(Residence.hasBiddings.amount)
If you want to determine the average amount of the appraisal value, the asking price and the mortgage of the current residence:
- AVG([Residence.appraisalValue, Residence.askingPrice, Residence.mortgage])
...
Overview
Content Tools