TTMSFNCCustomDataGrid.ColumnCalculation Method

Runs a one-off aggregate calculation on a column and writes the result into the grid.

API unit family: TMSFNCDataGrid Declaring type: TTMSFNCCustomDataGrid

Overloads

Overload 1

Runs a one-off aggregate calculation on a column and writes the result into the grid.

FMX.TMSFNCDataGrid.hppPascalC++

procedure ColumnCalculation(AColumn: Integer; AMethod: TTMSFNCDataGridDataCalculationMethod; ACalculationOptionsCallback: TTMSFNCDataGridDataGetColumnCalculationOptionsCallback = nil; ACustomCalculationCallback: TTMSFNCDataGridDataCustomColumnCalculationCallback = nil); overload;

void __fastcall ColumnCalculation(int AColumn, TTMSFNCDataGridDataCalculationMethod AMethod, Fmx::Tmsfncdatagriddata::_di_TTMSFNCDataGridDataGetColumnCalculationOptionsCallback ACalculationOptionsCallback = Fmx::Tmsfncdatagriddata::_di_TTMSFNCDataGridDataGetColumnCalculationOptionsCallback(), Fmx::Tmsfncdatagriddata::_di_TTMSFNCDataGridDataCustomColumnCalculationCallback ACustomCalculationCallback = Fmx::Tmsfncdatagriddata::_di_TTMSFNCDataGridDataCustomColumnCalculationCallback())/* overload */;

Remarks

Unlike ColumnCalculations, the calculation is not stored and does not refresh when data changes. OnBeforeSetColumnCalculation and OnAfterSetColumnCalculation fire when the result is written.

Parameters

Name	Description
AColumn	Zero-based column index.
AMethod	Calculation method (sum, average, minimum, maximum, count, distinct, standard deviation or custom).
ACalculationOptionsCallback	Optional callback that adjusts the calculation options (for example the output row or format); when nil, OnGetColumnCalculationOptions is used.
ACustomCalculationCallback	Callback for the custom method; when nil, OnCustomColumnCalculation is used.

Overload 2

Runs a one-off aggregate calculation on several columns and writes the results into the grid.

FMX.TMSFNCDataGrid.hppPascalC++

procedure ColumnCalculation(AColumns: TArray<Integer>; AMethod: TTMSFNCDataGridDataCalculationMethod; ACalculationOptionsCallback: TTMSFNCDataGridDataGetColumnCalculationOptionsCallback = nil; ACustomCalculationCallback: TTMSFNCDataGridDataCustomColumnCalculationCallback = nil); overload;

void __fastcall ColumnCalculation(System::DynamicArray<int> AColumns, TTMSFNCDataGridDataCalculationMethod AMethod, Fmx::Tmsfncdatagriddata::_di_TTMSFNCDataGridDataGetColumnCalculationOptionsCallback ACalculationOptionsCallback = Fmx::Tmsfncdatagriddata::_di_TTMSFNCDataGridDataGetColumnCalculationOptionsCallback(), Fmx::Tmsfncdatagriddata::_di_TTMSFNCDataGridDataCustomColumnCalculationCallback ACustomCalculationCallback = Fmx::Tmsfncdatagriddata::_di_TTMSFNCDataGridDataCustomColumnCalculationCallback())/* overload */;

Parameters

Name	Description
AColumns	Zero-based column indexes.
AMethod	Calculation method applied to every column.
ACalculationOptionsCallback	Optional callback that adjusts the calculation options per column.
ACustomCalculationCallback	Callback for the custom method.