Aggregation Strategies

JustPerform provides several approaches to aggregating data, from how individual metrics roll up within a sheet, to the summary methods applied across field hierarchies, to business rule engines that redistribute and consolidate values across models and entities. Understanding the available aggregation types helps you design sheets, models, and calculation processes that accurately reflect your organisation’s financial data.

Aggregation Types

Metric-Level Aggregation

Metrics are the key dimensions used to input or calculate data within a sheet. The type of metric you create determines how its values are produced and how they aggregate across field hierarchies. The metric types are Input, Parent, Formula, Summary, and Linked Metrics. For more information, see Metrics article.

Summary Methods

Every metric has a Summary Method setting that controls how values are aggregated when rolling up from leaf members to parent members in a field hierarchy. The available options are:

• Sum: Calculates the total sum of metric values.
• None: No summary method applied.
• Average: Computes the average of metric values.
• Min: Identifies the minimum value among metric values.
• Max: Identifies the maximum value among metric values.
• Ratio: Allows users to define a ratio for metrics.

Level Group Aggregation

Level Group is a feature that creates a virtual hierarchy by linking different leaf members. It allows users to maintain multiple levels of input within a single dimension, focusing on actual members only. Data aggregation happens automatically as users maintain the Level Group. Subfields add additional layers to the Level Group, allowing users to monitor which exact level a respective member belongs to.

Allocation

The allocation engine is a simplified and powerful rule engine for setting up complex allocation rules within the platform. The rule setup is business user-focused, easy to manage, flexible, and scalable. Allocation helps in redistributing source dataset values to single or multiple datasets based on driver values that determine how the values are allocated. Typical use cases include shared cost allocation, admin/marketing expenses allocation, product costing, profitability and cost analysis, cost distribution, and management reporting.

For more information, see Allocation article.

Account Mapping

Account mapping helps in transforming or copying source dataset values to a target dataset. It is beneficial for moving multiple datasets, aggregating them, and copying them to one target dataset. It is primarily used for simple cases like copying data.

Consolidation-Level Aggreagation

For organisations working with financial data across multiple entities and group structures, JustPerform provides a dedicated set of consolidation rules. These can be configured and executed through the Calculations area or directly from a sheet using the Consolidate Data in Sheet option. The rules which support data aggregation at the consolidation level are Group Consolidation Rule, Currency Conversion Rule, and Carry Forward Rule.

For more information, see Calculations and Consolidation Features articles.

Intercompany Elimination

Intercompany Elimination defines the rules for matching and eliminating intercompany transactions between entities within a group. Transactions between companies, such as the sale of goods or services, related revenues, cost of goods sold, and profits, are eliminated at the group or subgroup level. Where differences exist between the amounts recorded by the seller and buyer, the system autogenerates and posts offset values to a defined offset account. The method of elimination determines where any difference is posted: seller, byer, or offset.

For More information, see Intercompany Elimination article.

Automatic Journals

Automatic Journals post necessary adjustments for consolidation in addition to currency conversion and combined data. Rules are defined based on the dataset, version, and currency type in relation to the ownership structure. When executed, the system generates and posts journal entries for each applicable rule in the sequence they are defined, addressing dependencies. Posting targets include the consolidation model, the journal table, and an audit table that records only delta records.

For more information, see Automatic Journals article.