PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Overview
  • Defining the calculations to perform
  • Configuring the position of calculations
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
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,
  • Versions 22 and later
    maximum,
    New in version 22
    maximum,
    maximum,
  • Versions 22 and later
    minimum.
    New in version 22
    minimum.
    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.
Versions 22 and later
WINDEV By programming, you also have the ability to define specific calculation formulas and to display the result at the bottom of the relevant column. For more details, see Programming custom calculations in the tables.
New in version 22
WINDEV By programming, you also have the ability to define specific calculation formulas and to display the result at the bottom of the relevant column. For more details, see Programming custom calculations in the tables.
WINDEV By programming, you also have the ability to define specific calculation formulas and to display the result at the bottom of the relevant column. For more details, see Programming custom calculations in the tables.
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.
    • Versions 22 and later
      Minimum of values of column cells.
      New in version 22
      Minimum of values of column cells.
      Minimum of values of column cells.
    • Versions 22 and later
      Maximum of values of column cells.
      New in version 22
      Maximum 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 by 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…
Comments
Click [Add] to post a comment