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. |