Returns the mean of the values displayed in the rows of the table controls. The function accepts values only from textbox, label and literal controls. This function is called as <TableControlName>.MEAN("<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>.MEAN(controlName)
|
controlName |
It represents the name of the control which contains the values whose mean 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.MEAN(“UnitPrice”) |
The mean of those values only which are displayed in the rows of the “UnitPrice” control. |
|
= Order_DetailsTableControl.MEAN("Quantity") |
The mean of those values only which are displayed in the rows of the “Quantity” control. |
|
= Order_DetailsTableControl.MEAN("Discount") |
The mean of those values only which are displayed in the rows of the “Discount” control. |