Set up a formula for a measurement

Set up a formula for a measurement

Switch on low bandwidth view

Collapse All

Microsoft Dynamics AX 4

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.