PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • 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. Display the popup menu of the requested column.
  2. 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
  3. 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 Table control calculations (top or bottom of control and breaks) is a synchronous processing.

Deleting an automatic calculation

To delete an automatic calculation from a table column:
  1. Display the popup menu of the requested column.
  2. 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
  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 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 popup 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