STATISTICAL FUNCTIONS

Average [AVG]

Calculates the average of the given arguments.

Syntax

AVG (Number1, [Number2], ...)

Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.

Data Types of the Arguments

Integer, Number, Length, Area, Volume, or Angle (Must be identical for all arguments)

Data Type of the Result

Same as Arguments’ Data Type

Example

Columns are cut by a slanted Roof, so that each Column has both a maximum and a minimum height.

For any column, use AVG to find its average height.

Expression

AVG (Maximum Height of the Column, Minimum Height of the Column)

Result

3.08 (for a given column with a maximum height of 3.11 and a minimum height of 3.04)

Note

Both arguments are Length type data, so the Property’s data type must also be set to Length.