Defining Formulas and Frequencies

  To define formulas and frequencies:

1. On the Measure Setup page, select Calculations.

2. Specify how results indicate performance levels:

   • If high results indicate good performance, select High Result.

   • If low results indicate good performance, select Low Result.

3. Click Select in Units to identify the unit that quantifies the measure. For example, a unit for a measure called Total Revenue would be dollars.

4. Click the date selector button,, in Start Date to select the date on which to start collecting results.

5. If results (including period-to-date results) are not entered by a Result Collector using reports, click Select beside Result Formula to define the formula that calculates results. See Creating Complex Formulas.

6. Accept the default formula that calculates overall performance using the result and target or click Select beside Score Formula to define a different formula. See Creating Complex Formulas.

7. If the result you expect the measure to collect is affected by other data, or if you want to evaluate performance using targets, click Select beside Target Formula.

   Each multivalue target you create is listed, enabling you to define a target formula for each.

   Note:

   Target values entered by Target Setters using reports override values calculated by formulas.

8. Optional: In Result Source Repository, enter the name of the source from which to take results. This is purely descriptive text.

   For example, if measure data is housed in a General Ledger database, enter the name of the database.

9. Click Select beside Collection Frequency to choose a frequency that determines the dates on which result values should be entered or available.

   The Select Frequency box is displayed. If you use a 52/53–week year, and want to collect results monthly, select Monthly (week-based).

10. Click Select beside Measure Reporting Frequency to determine the dates with which result values are associated in reports. This frequency determines when collected result values are active in reports.

    For example, if company wants track the amount of money made each month on sales they can avoid overlapping with other months by specifying a reporting frequency of monthly, with a period of the last day. This ensures that sales for January, for example, only display in January and not February. If sale figures for each month are not available until the middle of the following month, a collection frequency specifying the 15th of every month ensures that results for each month are associated with that month although they are not collected in that month. For example, although January sale results are not collected until February 15th, they are displayed for January in reports.

11. Optional: To give result collectors additional days in which to enter results, enter a value in Collection Extension..

12. Click Select beside Target Collection Frequency to choose a frequency that determines when target values are meant to be entered or calculated.

    The Select Frequency box is displayed. If you use a 52/53 week year, and want to collect targets a monthly, select Monthly (week-based).

13. Click Select beside Target Reporting Frequency to generate a list of dates with which target values are associated in reports. For example, this would enable you to specify that a target value entered in March but applied in June is associated with June in reports.

14. Optional: To give target setters more days during which they can enter values, enter a Target Collection Extension.

15. Click Next. See Defining Report Options and Assigning Employees.