Version 5.1.2.0
This document contains confidential information. Not to be copied by third parties without written authorization.
© Copyright Corporater AS - All rights reserved.
The GRP (group) function is used mainly to create summing levels that do not exist in the node tree, to be used in a drill.
GRP('[100]+[300]+[500]')
Use GRP when you want to add together nodes that are located in different places in the node tree structure.
Example
The nodes "Travel expenses", "Insurance", and "Salary" are located in different places in the node tree structure. You want to add them together and show the sum as "Personnel costs" in drills. This can be expressed in the following way:
AGG('GRP('[150]+[160]+[170]') as 'Personnel costs' ',100)
which means:
AGG('GRP('[Salaries] + [Employee insurances] + [Travel expenses]') as 'Personnel costs' ',My organization)
In the Function calculator, click the GRP button and choose GRP. A new calculator window opens. Now create the function in the normal way by defining time adjustments, selecting nodes, and clicking on or entering numbers and operators. Click OK when finished.
Version 5.1.2.0
This document contains confidential information. Not to be copied by third parties without written authorization.
© Copyright Corporater AS - All rights reserved.