AVERAGE

Returns the average of the values displayed in the rows of the table control. The function accepts values only from textbox, label and literal controls. This function is called as <TableControlName>.AVERAGE("<ControlName>"). Use a TableControl instance to indicate which TableControl contains the values to be operated on by the function (e.g., Order_DetailsTableControl, ProductsTableControl, CategoriesTableControl).

Syntax

= <TableControlName>.AVERAGE(controlName)

Parameters

controlName

It represents the name of the control which contains the values whose average is to be calculated. The controlName should be a string (e.g., “UnitPrice”, “Quantity”, “Discount”). The values in the control can be an integer (e.g., 37), a decimal value (e.g., 37.48), or a string.

Return Type

Decimal

Examples

Example

Returns

= ProductsTableControl.AVERAGE(“UnitPrice”)

The average of the values displayed in the rows of the “UnitPrice” control.

= Order_DetailsTableControl.AVERAGE("Quantity")

The average of the values displayed in the rows of the “Quantity” control.

= Order_DetailsTableControl.AVERAGE("Discount")

The average of the values displayed in the rows of the “Discount” control.