Calculating Column

The "calculating column" data type is available in all table types and analyses except for the segment report. With the calculating column, you can perform calculations with value columns (data streams or analysis rows) and display the results in a new column.

The calculating column definition settings are grouped under Formula and Settings.

Formula

When defining the formula, you can access all the available columns via the constant C (Column). However, a calculation will only be performed if the respective columns are data or analysis columns with numerical values.

Arithmetic operators

The following calculation methods are available:

Examples:

C2*1.15

C3-C2

(C3-C2)/C4

Sum function

With the SUM function, you calculate the sum of multiple columns. Specify the desired columns inside round brackets "()" separated by a ";" (semicolon). Define a series of consecutive columns with a ":" (colon).

Examples:

SUM(C2:C3;C5)

SUM(C2;C4;C7)

Settings

In the settings, define the underlying data stream (for variances, the data streams to be compared), the currency (optional), the time span and time offset relative to the current time slider setting or a manually defined time span with a start date and an end date, and the underlying organization.

All global options in the settings refer to the settings defined for the table type. To make an individual selection, turn off the "Global" switch and select the desired reference for the calculating column.