Dimension/Column | Displays information about the column definition line. The symbol ⭮ indicates that this is a dimension loop in which the values of the dimension are run through. The indentation displayed here has no influence on the display of the evaluation result and is only used to show the structural design of the column definition. The column type or the dimension of a loop can be changed by clicking on the field. |
Header | Specifies text that will be added to the column header. If no text is specified, the type of column will be added. |
Formula ID | Specifies an ID that can be used to access the columns in formulas. In formulas, only columns from the same loop run and columns from the parent/subordinate loop can be accessed. Columns from higher/lower level loops can only be accessed via intermediate steps. |
Value Filter/Formula | Specifies which dimension values are to be taken into account in a dimension loop, or specifies a formula. Formula: If a Column Reference is specified in the Line Definition, the reference can be accessed with the % and = operators. The operator % calculates the percentage of the column amount related to the line amount. The = operator can be used to access the line amount directly. |
Group Filter | Specifies which dimension groups are to be taken into account in a dimension loop. |
Value Type | Specifies which dimension value types should be considered or calculated in a dimension loop.
In contrast to the evaluation lines, only values of the type Standard, Total and End-Total can be displayed in the columns.
|
Rounding Factor | Specifies the factor that should be used to round the result in this column. |
Show Opposite Sign | Specifies whether the sign of the result in this column should be reversed. |
Value Calculation (Date View) | Specifies how values are calculated in the column when the Date View is activated in the evaluation.
|
Date Formula (Date View) | Specifies a date formula that can be used to influence or change the date filter set by the Date View for this column. The field is displayed only if the date view is enabled in the evaluation. |
Bold | Specifies whether to print the column in bold or not. If no specification is selected, the actual bold setting from the values will be used. |
Italic | Specifies whether to print the column in italics. |
Parting Line Left | Specifies whether to print a parting line to the left of the entire column or only in the result area (line area) of the column. |
Parting Line Right | Specifies whether to print a parting line to the right of the entire column or only in the result area (line area) of the column. |
Show | Specifies whether the column should be displayed. |
Filter | View or set up the filters that will be used to calculate the values. |
Date Filter | Specifies a filter that will be used to calculate the values.
Note It is possible to specify IDs (placeholders) in date filters that will be calculated and replaced based on the Date Filter Calculation Date when the evaluation is executed. A list of Date Filter ID examples can be opened via the lookup of the field. For more information, see Reports and Analysis, Edit Evaluations, Date Filter IDs. |
Cost Type Filter | Specifies a filter that will be used to calculate the values. The caption of the field depends on how the cost type is set up in the Cost Dimension Setup. |
Cost Dimension Filters | Specifies filters that will be used to calculate the values. The caption and number of fields displayed depend on how the cost dimensions are set up in the Cost Dimension Setup. |
Work Type Filter | Specifies a filter that will be used to calculate the values. |
Budget Filter | Specifies a filter that will be used to calculate the values. |
Comment | Specifies a comment. |
fiskaltrust POS Interface Extension to meet legal national requirements for the fiscalization of POS systems. More Information AppSource |