Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
bgColorwhite
AVERAGE

AVG (

AVG

for average)


Use this function to determine Determines 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.


1. Collection form syntax

Code Block
AVG ( attribute )



Input
  • attribute - An attribute of any type of integer, number or date of which multiple instances can occur at runtime.


2. List form syntax

Code Block
AVG ( [ value1 , value2 , ... ] )



Inputs
  • [ value1 , value2 , … ] - A list of attributes, expressions or fixed values of any type of integer, number or date. Use the square brackets to indicate that the arguments form a list of values.


Return types

  • number
  • currency
  • percentage
  • date

The function returns UNKNOWN if one or more values are UNKNOWN.


Examples

Suppose the following domain model.


Entity.attributeValueMultivalued relationEntity.attributeValues

Residence.appraisalValue

Residence.askingPrice

Residence.mortgage

€ 140000

€ 150000

€ 142000

hasBiddingsBidding.amount

€ 132000

€ 139000

€ 137500

GoalExpressionResultType
To determine the average amount within the appraisal value, the asking price and the mortgageAVG ( [ Residence.appraisalValue , Residence.askingPrice , Residence.mortgage ] )€ 144000Currency
To determine the average bidding on the current residenceAVG ( Residence.hasBiddings.amount )€ 136166.67Currency



Back to top