Understanding the components of calculations
The order of calculation calculates values based on measures, locations, and periods.
*Measure
Formula measures contain a formula which is performed on its submeasures. For example, Measure A * Measure B. Data measure values may be entered directly into the system by a user.
*Location
Locations get their data values from their sublocations. For example, the North America data value may based on the Canada, USA, and Mexico sublocations.
*Period
Periods are based on the consolidating range and the frequency of the measure. For example, a common consolidation range is This Year To Date and a common period frequency is Month.