Skip to Content
0
Former Member
Aug 02, 2006 at 06:21 PM

Calculating Hierarchy Nodes At Reporting

263 Views

When using a hierarchy for reporting, is there a way to create a node that is the result of a calculation of values in other nodes? The hierarchy is built from the 0ACCOUNT characteristic. There are accounts that are grouped into lots of nodes to support P&L reporting. For example, there is a node called Gross Sales, Net Sales, Std direct cost etc. I want to be able to create/show a 'node' called 'Margin %' that would be the result of a calculation based on other node values (ex. Margin / Net Sales * 1000.) This needs to be a BEx query.

Any ideas? Thanks