Help / Developing an application or site / Controls, windows and pages / Controls: Available types / Table Column control
  • Overview
  • Defining the calculations to perform
  • Configuring the position of calculations
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
When a Table control contains numeric data, it may be useful to find out the total of a column or to count the number of elements.
WINDEV allows you to automatically perform and display calculations for the columns:
  • sum,
  • mean,
  • count,
  • maximum,
  • minimum.
Examples of calculations performed in the columns of a Table control:
  • the total number of parts ordered,
  • the number of students with an email address,
  • the average sum spent by each customer.
Defining the calculations to perform
To perform one or more calculations on a column:
  1. Open the Table control description window ("Description" in the popup menu).
  2. Select the name of a column for which a calculation must be performed.
  3. Display the "Details" tab of this column (in the lower part of the screen).
  4. Select the calculations to perform:
    Available calculations
    • sum of column cells,
    • average of column cells,
    • count of non-null values in the column. If the Table control contains merged cells, they are considered as having a null value.
    • Minimum of values of column cells.
    • Maximum of values of column cells. Remark: The available calculations depend on the type of column. The counter is available for all types of columns.
  5. Repeat the operations 2 to 4 for all the columns on which a calculation must be performed.
Remark: the different calculations can be handled through programming via specific constants. For more details, see Programming calculations in the Table controls.
Configuring the position of calculations
To configure the position of calculations:
  1. Open the "General" tab of the Table control (to do so, select the name of the Table control and click the "General" tab).
  2. In "Show results", indicate where the totals will appear. To display the results:
    • on one or more rows added directly after the last row of the control, select "After the last row, in the Table control".
      For example:
      Added rows
      These rows are visible:
      • at the bottom of the Table control if the control includes no vertical scrollbar.
      • when the vertical scrollbar is located at the very bottom if the Table control includes a vertical scrollbar.
    • below the Table control., select "Below the Table control".
      For example:
      Rows below the Table control
      These rows are always visible.
    • You can also perform automatic calculations without displaying them ("No display").
  3. If necessary, modify the caption displayed in front of the calculations ("Modify the captions").
  4. Validate the Table control description window.
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment

Last update: 08/25/2022

Send a report | Local help