View table - Totals calculation

Applications module View table Properties Data tab / Edit total calculation

In this dialog box, the cells of the total calculation of a table can be configured. Only the columns that are visible in the table (i.e. that are not hidden) can be used in the calculation. Under each column name, you will see a corresponding number. This number represents the index used in the calculation for a table column.

Please note that for actions such as adding, moving, or deleting table columns, that only the index of the visible columns is adjusted in the area of the total amount. The contents of a column are not automatically moved, but they may be deleted, depending on the action. Adjustments to the content must be performed by the users themselves. Columns are always added or deleted at the end of the total amount area.

Add control
Opens a menu where you can select whether you'd like to add a Static text or a Calculation.

Delete control
The currently selected control is removed. Place controls for the calculation in the free cell underneath the column index of the column that needs to be calculated.

Edit control
Opens the Formula editor.

Edit table
Opens a menu with the following functions:
Moves columns and cells with controls to the left or right, respectively.

Moves rows up or down, respectively.

Move content via drag & drop

Cell contents can also be moved to empty cells via drag & drop. However, in contrast to moving via the arrow buttons, only the contents of the cells will be moved, not the properties of the cells.