- Overview
- Defining the calculations to perform
- Configuring the position of calculations
Calculations in the columns of a Table control
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: - Open the Table control description window ("Description" in the popup menu).
- Select the name of a column for which a calculation must be performed.
- Display the "Details" tab of this column (in the lower part of the screen).
- Select the calculations to perform:
- 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.
- Repeat the operations 2 to 4 for all the columns on which a calculation must be performed.
Configuring the position of calculations To configure the position of calculations: - Open the "General" tab of the Table control (to do so, select the name of the Table control and click the "General" tab).
- 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: 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: These rows are always visible. - You can also perform automatic calculations without displaying them ("No display").
- If necessary, modify the caption displayed in front of the calculations ("Modify the captions").
- Validate the Table control description window.
This page is also available for…
|
|
|
|