Calculating Data

You calculate data from data grids on the Desktop or on the Web. In addition to data grids, you can also calculate data from the Process Control module on the Web.

When you calculate data, calculation rules run for the selected scenario, year, period, entity, and value. In addition, all prior time periods within the same year that were not previously calculated are calculated. For example, if you calculate data for June, data that was not previously calculated for January through May is calculated.

You can calculate contribution values rather than parent values. Contribution values are values added to a parent by a dependent entity. When you select contribution values, this populates the Value dimension members of the current entity without rolling the contribution total up to the parent entity. You can also force calculation to generate contribution values.

After you calculate data, the Calculate Data menu option is disabled. If you load or enter new data or metadata, the Calculate Data menu item is reenabled. If the Calculate Data option is not enabled, you can use the Force Calculate option to calculate data.

  To calculate data:

  1. From the data grid, select the point of view.

  2. Select the cell for which to calculate data.

  3. Right-click and take one of these actions:

    • To calculate the selected cells, select Calculate.

    • To force calculation to run for all selected cells, select Force Calculate.

    • To calculate contribution values, select Calculate Contribution.

    • To force calculation to run for all selected contribution values, select Force Calculate Contribution.