Automatic calculations in a Table control (AAF)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Overview
Displaying (or not) an automatic calculation
Displaying an automatic calculation
Deleting an automatic calculation
Programming
Proposing an automatic calculation

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Popup menu associated with Table controls and their columns (AAF)

Automatic calculations in a Table control (AAF)

Overview

In the Table and TreeView Table controls, the end user has the ability to add automatic calculations. These calculations are available for all types of columns.

Displaying (or not) an automatic calculation

Displaying an automatic calculation

To display an automatic calculation in a table column:

Open the context menu of the requested column.
Select "Automatic calculation (sum, average, ...)" then select the requested calculation type:
- Sum
- Number of elements
- Average
- Versions 22 and later
  Minimum
  New in version 22
  Minimum
  Minimum
- Versions 22 and later
  Maximum
  New in version 22
  Maximum
  Maximum
The calculation is automatically performed and it is added below the table. It is always visible.

Caution:

The popup menu used to add or delete automatic calculations is not available for all types of columns.
The popup menu for adding or deleting automatic calculations is not available on "Direct access" Table controls with more than 1000 rows (in order to optimize calculation times).
The execution of the automatic calculations in a Table control (top or bottom of the control and breaks) is a synchronous process.

Deleting an automatic calculation

To delete an automatic calculation from a table column:

Open the context menu of the requested column.
Select "Automatic calculation (sum, average, ...)" then select the type of calculation to delete:
- Sum
- Number of elements
- Average
- Versions 22 and later
  Minimum
  New in version 22
  Minimum
  Minimum
- Versions 22 and later
  Maximum
  New in version 22
  Maximum
  Maximum
The calculation is automatically deleted for the selected column.
Caution: If the calculation exists for other columns, the calculation line will still be displayed below the table.

Caution: The popup menu used to add or delete automatic calculations is not available for all types of columns.

Programming

Proposing an automatic calculation

Automatic calculations are proposed by default in the context menu of table columns (for the types of columns that allow them).

Reminders:

An automatic calculation can be displayed in a Table or TreeView Table control. Simply define the calculation to perform in the column description window. For more details, see Calculations in the columns of a Table control.
Versions 22 and later
Custom automatic calculations can also be added into the columns of a Table control. For more details, see Programming custom calculations in the tables.
New in version 22
Custom automatic calculations can also be added into the columns of a Table control. For more details, see Programming custom calculations in the tables.
Custom automatic calculations can also be added into the columns of a Table control. For more details, see Programming custom calculations in the tables.