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).
= <TableControlName>.AVERAGE(controlName)
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. |
Decimal
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. |