Create formulas to define how result values, target values, and scores are computed and evaluated to determine overall measure performance as follows:
Target formulas—Use if the results or scores of other measures affect the target of a measure. For example the target for a measure monitoring “Product Sales” could be the result of this measure from the previous year plus 15%.
Result formulas—Use if data for other objects impacts the result of a measure. For example, a result formula for a composite measure called “Net Profit” would include results for measures such as Cost of Sales and Operating Expenses.
Score formulas—Determine how results are evaluated to produce a score that reflects overall performance. By default, Performance Scorecard uses this formula that calculates scores by dividing a measure's result by its target:
mResult (this)/mTarget (this)
“This” represents the current measure.
Use the Formula Editor to create complex formulas using functions to insert the following data:
Measure results, scores, targets, and variances
Variable results
Scorecard scores
To build formulas using data previously collected, use time-related functions such as timeOffset.
For more information, see Creating Complex Formulas.