|
|
|
|
|
- Overview
- Displaying (or not) an automatic calculation
- Displaying an automatic calculation
- Deleting an automatic calculation
- Programming
- Proposing an automatic calculation
Automatic calculations in a Table control (AAF)
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
- Minimum
- Maximum
- The calculation is automatically performed and it is added below the table. It is always visible.
Caution: - The context menu used to add or delete automatic calculations is not available for all types of columns.
- The context 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
- Minimum
- Maximum
- The calculation is automatically deleted for the selected column.
Warning: If the calculation exists for other columns, the calculation row will always be displayed below the table..
Please note: The context menu for adding or deleting automation calculations is not available for all column types.. 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:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|