Calculation Commands

Calculate routines are executed for a given intersection of scenario, year, period, entity, and value. Executing Calculate routines results in writing or clearing data in the current data table, which corresponds to the current intersection of scenario, year, period, entity, and value. When users execute Calculate routines, the system can read data from anywhere in the application. However, data is only written to the current data table.

Note:

The calculate routine fill fail if you have the [None] entity in a hierarchy when you consolidate.

Users run these processes in data grids by selecting one of these commands:

When a user selects a calculation command, Financial Management executes the Sub Calculate() routine in the RLE file. The Calculate() routine calculates accounts and custom dimension members for a given Entity-Value combination within a given Scenario, Year, and Period.