Recalculate a Metric Template

After you have introduced changes that might affect worksheet data such as adding or modifying a formula or changing defaults, the worksheets associated with the metric template may need to be recalculated. If Needs Recalculation displays next to the name of a metric template, or if recalculation is recommended on the metric template's Summary tab, it is important that you initiate the recalculation process.

Caution: If a large number of worksheets use the metric template, the recalculation process can require several hours to complete.

1. Click Start Recalculation

Click Start Recalculation

2. Recalculation from Metric Template List

Recalculation from Metric Template List

  • Click Needs Recalculation.

2.1 Click Start Recalculation

Click Start Recalculation

  • Click Start Recalculation.

2.2 Confirm Recalculation

Confirm Recalculation

  • Click OK.

2.3 View Recalculation Results

View Recalculation Results

  • Scroll to the bottom of the screen to view results of the recalcuation.

3. Recalculation on Summary Tab

Recalculation on Summary Tab

  • On the metric Summary tab, click Start Recalculation.

Recalculate Fully despite of locked periods: If selected, all metric worksheets, including those with locked periods, will be recalculated.

3.1 View Progress

View Progress

  • View the recalculation progress bar.

Note: The metric template cannot be edited while the recalculation process is in progress.

3.2 View Metric Summary

View Metric Summary

  • View updated metric summary.