Formula (Extended): $AVERAGE Function

2023-12-062024-06-07

Overview¶

Calculate the average (arithmetic mean) of the arguments.

Syntax¶

$AVERAGE(Num1, [Num2],...)

Parameters¶

Parameter	Type	Required	Description
Number1	Half-width numeric value	Required	The first numeric value to calculate the average of.
[number2],...	Half-width numeric value	Optional	Additional numeric value to calculate the average of.

Column Usable as Parameters¶

Parameter	Classification	Numeric Value	Date	Description	Check
Num1	Yes	Yes	No	Yes	No
[Num2]	Yes	Yes	No	Yes	No

Return Value¶

Average (arithmetic mean) of the arguments.
An error will occur if an error value or a string that cannot be converted to a numeric value is specified as an argument.

Return Value Display Content¶

Target	Display Content of Return Value
Classification (including title, status, manager, owner)	Display return value. In the case of a drop-down list with values, the options that match the return value are displayed.
Numeric Value (including work volume, progression rate, remaining work volume)	Display return value.
Date (including start and completion)	Do not display.
Description (including content)	Display return value.
Check (including lock)	Do not display.