Overview tab

Create and view all available columns.

General tab

View or change all base settings of the column that is selected on the Overviewtab.

Formatting

Select or view formats of the column that is selected on the Overviewtab.

Column dimension

Select or view the dimension and date intervals of the column selected on the Overviewtab. This tab is displayed only for columns with the costs fixed, variable, total, and quantity column types.

Calculation

Select or view a calculation expression for a column calculation column type that you select on the Overviewtab.

Column reference

Select or view a column reference for a 100% column type that you select on the Overviewtab.

Column name

Generate or view the column number.

Column name

Enter, manage, or view the description of the column.

Column header

Enter, manage, or view the column header which is shown on the report.

Column type

Select one of the following column types:

• Line number- The line number of the report column.

• Name- The name of the report column.

• Costs, fixed- The realized or planned fixed costs on a report column.

• Costs variable- The realized or planned variable costs on a report column.

• Costs total- The realized or planned total costs on a report column.

• Quantity- The realized or planned quantities on a report column.

• Column calculation- A column that is calculated based on other columns. The current calculation is specified by a calculation expression in columns 1 and 2.

• 100%- A calculation of the cost line's share of the 100% cost line in the column that is marked on the line in Percentage column.

Value type

Select one of the following value types:

• Budget costs

• Basic plan costs

• Flexible plan costs

• Target costs

• Actual costs

Budget model

Select a forecast model.

Note
This field is not active when the Value typeis like Actual costs.

Print

Select the check box if the column should be printed on the report. The column can be a component of other calculated columns.

Number format

Select one of the following number formats:

• Unchanged- This format is the default and shows the values without any changes.

• In thousands- This format indicates whether the column should display the value in thousands.

• In millions- This format indicates whether the column should display the value in millions.

Decimal separator

Select the sign that will be used as the Decimal separator.

Thousands separator

Select the sign that will be used as the Thousands separator.

Show zero

Select if the value zero is shown.

Invert sign

Select if the values should be inverted.

Sign

Specify how to show a sign for negative figures.

Decimals

Specify the number of decimal places.

Negative adjustment

Enter the number of positions that negative figures should be moved to the left.

Length

The maximum number of positions in the column when you print it.

Evaluate division

Use this check box to select a division instead of a dimension.

Dimension

Select or view the dimension type.

Number

Select the dimension value for the column.

Division

Select the division for the column.

Date interval code

Select the date interval code.

From date

Specify the from date if you left the date interval code blank.

To date

Specify the to date if you left the date interval code blank.

Calculation expression

Select the formula that is used for calculating a column using other already created columns. During calculation, #1 and #2 will be replaced by the currently specified columns Column 1 and Column 2. Select from the following options:

• #1-#2 = the difference between the columns marked in Column 1 and Column 2.

• #1+#2 = the sum of the columns marked in Column 1 and Column 2.

• #1+...+#2 = the sum of the interval of columns marked in Column 1 and Column 2.

• #1*#2 = the product of the columns marked in Column 1 and Column 2.

• #1/#2 = the ratio of the columns marked in Column 1 and Column 2.

• #1/#2 % = the ratio of the columns marked in Column 1 and Column 2, calculated as a percentage.

• (#1-#2)/#2 % = the difference between the columns marked in Column 1 and Column 2, as a percentage of the column marked in Column 2.

• (#1-#2)/#1 % = the difference between the columns marked in Column 1 and Column 2, as a percentage of the column marked in Column 1.

Column 1

Select a column with the first operand in the leading expression.

Column 2

Select a column with the second operand in the leading expression.

Reference column

Select or view the reference column number for the calculation.

Reference line

Select or view the reference cost line for the calculation.