TTMSFNCDataGridDataCalculationMethod Enumeration
The aggregate function applied by a column or row calculation.
API unit family: TMSFNCDataGridData
Remarks
Only normal data rows (not group header or summary rows) and only the base cell of a merged range take part. Hidden rows take part unless TTMSFNCDataGridDataCalculationOptions.IncludeHiddenRows is set to False.
Members
| Name | Description |
|---|---|
gcmSum |
Adds the numeric values in the range. Empty and non-numeric cells contribute 0. |
gcmAverage |
Divides the sum by the number of participating cells, including empty cells, or returns 0 when there are none. |
gcmMin |
Returns the smallest value in the range. Empty and non-numeric cells are read as 0. |
gcmMax |
Returns the largest value in the range. Empty and non-numeric cells are read as 0. |
gcmCount |
Counts the participating cells in the range, including empty cells. |
gcmCustom |
Delegates the calculation to the supplied custom calculation callback, or to OnCustomColumnCalculation / OnCustomRowCalculation when no callback is supplied. |
gcmDistinct |
Counts the distinct text values in the range, compared case-insensitively. |
gcmStandardDeviation |
Computes the spread of the values around their average: the square root of the summed squared deviations divided by the number of participating cells plus one. |