Calculates the degree of goal accomplishment of column values one row at a time, based on the rating and the two planned values for 100% and 0%.
The following parameters are available.
Parameter |
Description |
---|---|
Calculation column value |
Name of the column for which the goal accomplishment is calculated. Source: Source table Data type: Number Specification: Mandatory |
Rating |
Rating of the column values for which the goal accomplishment is calculated. Valid values: Positive or Negative Positive: Higher values are assessed as positive, for example, sales revenue Negative: Higher values are assessed as negative, for example, process throughput time. Data type: Text Default value: Positive: Specification: Mandatory |
100% relates to |
Target values that are compared with the source values. Source: Source table, single-value operator, input value, or a constant. Data type: Number Specification: Mandatory Goal accomplishment depends on the rating: Positive rating: Source values >= target values Negative rating: Source values <= target values |
0% relates to |
Target values that are compared with the source values. Source: Source table, single-value operator, input value, or a constant. Data type: Number Specification: Mandatory Goal accomplishment depends on the rating: Positive rating: Target values <= source values Negative rating: Target values >= source values |
Target column |
Name of the column to which the result is written. Source: Source table or constant. Default value: Result_1 Data type: Number Specification: Optional |