It would be helpful to have an “aggregation operator” property that would apply to a hierarchy.


For example, consider the following hierarchy, applied to a module, with the following values:


Net Income: $10

Gross Margin: $40

Sales: $100

Cost of Sales: $60

Operating Expense: $30


Clients would prefer to see Cost of Sales as a positive number. In aggregating, they would want to see Cost of Sales subtracted from Sales to arrive at a positive Gross Margin number.


The obvious answer here is that we create line items to represent this logic.


Yes, we can do that, but now imagine you have a 10,000 account hierarchy, and you need to pull data into a module that is dimensionalized by Account. You are now in a position of managing 10,000 formulas to pull data from a record table into your dimensionalized planning + reporting module.


This idea would significantly reduce the amount of calculations and tracking required to perform this logic. In short, the idea is that if we could enable a property that would let us specify whether an item, upon aggregating, should subtract the value stored at that intersection or add it.

4 votes

New · Last Updated


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!