AVERAGE
Syntax
AVERAGE (numeric_expression, numeric_expression, ...)
Description
Finds the mean or average value of a series of numeric expressions.
Arguments
| numeric_expression | A number that can be converted to a Double64 number. |
Returns
A numeric value in Double(64) format. A Double32 or Double64 data type represents a 32- or 64- double-byte floating-point number.
Remarks
Using AVERAGE with Decimal data greater than 64 bits may result in a loss of precision.
Decimal (128) data type is a decimal number with a maximum length of 128 bits.
Note: Many functions return a numeric value smaller than the maximum length of decimal. If your data is longer than 32 bits, make sure you understand what the return value is. Any extra digits are truncated.
Examples
AVERAGE (13.50, 56.75, 200.60)
Returns: 90.28
If your source data contains the following fields and data:
Transaction1 (13.50), Transaction2 (200.60), Transaction3 (56.75)
The following formula will return the same result:
AVERAGE (MyEntity.Transaction1, MyEntity.Transaction2, MyEntity.Transaction3)