ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Automatic Application Features (AAF) / AAF on Tables/TreeView Tables
  • Overview
  • Displaying (or not) an automatic calculation
  • Displaying an automatic calculation
  • Deleting an automatic calculation
  • Programming
  • Proposing an automatic calculation
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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:
  1. Open the context menu of the requested column.
  2. Select "Automatic calculation (sum, average, ...)" then select the requested calculation type:
    • Sum
    • Number of elements
    • Average
    • Minimum
    • Maximum
  3. 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:
  1. Open the context menu of the requested column.
  2. Select "Automatic calculation (sum, average, ...)" then select the type of calculation to delete:
    • Sum
    • Number of elements
    • Average
    • Minimum
    • Maximum
  3. 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 context 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:
Minimum version required
  • Version 17
Comments
Click [Add] to post a comment

Last update: 01/31/2024

Send a report | Local help