SCORE

Purpose

The SCORE function calculates a metric’s score for a specified context of actual, target, and tolerance indicators.

This function returns a value that indicates whether a metric is on target, higher than the target, or less than the target, and by how much. It reflects the distance from the target as measured in units of tolerance. It returns values in the range of -10 to 10 where a value of 0 indicates that the metric is on target. A positive score indicates that the metric is on target. A negative score indicates that the metric is not on target.

This function is valid only in a cube that has a metric dimension and can determine the performance pattern of the metric and the tolerance type.

=SCORE('<Actual>','<Target>'),'<Tolerance>'

Parameters

Actual: The name of the metric indicator that represents the Actual indicator.
Target: The name of the metric indicator that represents the Target indicator.
Tolerance: The name of the metric indicator that represents the Tolerance indicator.

Sample

For example, this function is used by the default metric indicator named Score.

=SCORE('Actual','Target','Tolerance')