Summary Calculations

Detail Row

For tables with two detail rows, you can choose the detail row for which you want to configure the summary calculation. If you configure summary calculations for both detail rows, the results will be shown in separate lines under each other. However, for a better overview of the results, we recommend creating a summary calculation only for one specific detail row.

Select Summary Calculation

Here, you define the footer rows of the selected table column. Each selected function appears in a separate footer row. In contrast to the summary calculations for specific table groups, this summary calculation applies to the entire table.

If you provide a name in the Variable Name field, you can access the corresponding summary information under this variable name in subsequent report items.

The names of the functions (for example, Min or Max) are automatically written into the column left to the one for which you configured the first summary calculation. If you configured a summary calculation in the leftmost table column, RTE will add an additional column to the left of this column.

The fields are only active for columns containing numbers. If you edit the properties of a column containing, for example, the sample name, the fields are inactive.

The Standard Deviation calls the STDEV function (see Aggregate).

Number Format for Summary Calculations

You can configure the number format for all functions at the same time or separately for each selected function. Select All or the particular function in the Summary calculation drop-down list.

Number Format

With Number Format, you can choose the way in which numbers are shown, for example, as a decimal number, date, or currency. Depending on the category selected in the drop-down list at left, you can choose between different styles in the drop-down list at right.

Rounding

Define the precision of a number, currency, or percentage.

  • Decimal Places

    The number is shown with the given amount of decimal places.

  • Significant Digits

    The number is masked with zeros, only the specified number of significant digits is shown.

    For example, if you set the significant digits to 2, the numbers are shown as follows:

    1234 as 1200

    1 as 1.00

    0.1234 as 0.12

    0.1 as 0.10

    0.01234 as 0.012

Preview

The Preview area shows the appearance of the currently selected settings.