Aggregate (Built-in Functions)
Avg - Gets the average of all of the values of a property.
Expression Syntax: Avg({property})
property
A property, eg Population.
Example:
Avg({Population@})
Gets the average of all the values of Population.
Max - Gets the larger of two numbers or the largest value of all of the values of a property.
Expression Syntax: Max(number1,number2)
number1: The first number or property.
number2: The second number or property.
Example:
Max(10,20) or Max(Population@)
Obtains the largest value of the numbers (10,20) or the largest value of Population.
Min - Gets the smaller of two numbers, or the smallest value of all of the values of a property.
Expression Syntax: Min(number1,number2)
number1: The first number or property.
number2: The second number or property.
Example:
Min(10,20) or Min(Population@)
Gets the smallest value of the numbers (10,20) or the smallest value of Population.
Sum - Gets the sum of all of the values of property.
Expression Syntax: Sum({property})
property
The property to be summed
Example:
Sum({Population@})
Gets the sum of all the values of Population.