Set up a formula for a measurement

MSDN Home

MSDN
MSDN Library
Servers and Enterprise Develop ...
Microsoft Dynamics
Microsoft Dynamics AX
Microsoft Dynamics AX 4.0
Microsoft Dynamics AX
Using Microsoft Dynamics AX
Microsoft Dynamics AX User's G ...
Balanced scorecard
Measurements

Switch View :

Classic

Lightweight Beta

ScriptFree

Feedback

Microsoft Dynamics AX 4

Set up a formula for a measurement

Click Balanced scorecard >
Select the objective to which the measurement is assigned, and then click Measurements.
Select an item and click the Formula tab.
Under Elements, select an element identification in the ID field to add it to the Formula.
The Elements box displays all active elements for the measurement. The list is updated automatically, but you can click Refresh to ensure that all active elements are shown.
In the Formula box, complete the formula by including the mathematical operators (plus (+) for addition, minus (-) for subtraction, forward slash (/) for division, and asterisk (*) for multiplication) between the element identifications.
Click Verify formula to check the formula for errors.

Example

You have created two elements for a measurement, one of which represents the total number of employees (100-1), and one of which represents the total number of employees who possess a Masters Degree (100-2). Once you have selected the two elements they appear in the Formula box as [100-1] [100-2]. To calculate the percentage of employees with a Masters Degree, you must add the mathematical operators to the formula, which now appears as [100-2] / [100-1] * 100.