Member calculations
Member calculations apply to selected members on a row or column.
If a single member is selected, you can choose from the following calculations.
Calculation name | Description |
---|---|
Rank | Ranks the values of the selected member. Rank 1 is the highest value. Rank is applied to the values visible in the view. If you drill down or roll up consolidations in the view, or if you modify the set used in the view, rankings change to reflect the ordering of the values that are visible in the view. If you attempt to rank a mixture of string and numeric values, the string values are assigned a rank equivalent to a NULL numeric value. String values will always be ranked below any numeric values. |
Absolute value | Displays the absolute value for the selected member. |
% of total | Displays the member value expressed as a percentage of the root level consolidation (total). |
% of parent | Displays the member value expressed as a percentage of its immediate parent. |
Member Name + | Enter a numeric value in the entry box. Displays the sum of the member value and the specified numeric value. |
Member Name - | Enter a numeric value in the entry box. Displays the difference of the member value minus the specified numeric value. You can click |
Member Name / | Enter a numeric value in the entry box. Displays the quotient of the member value divided by the specified numeric value. You can click |
Member Name * | Enter a numeric value in the entry box. Displays the product of the member value and the specified numeric value. |
If two members are selected, you can choose from these calculations.
Calculation name | Description |
---|---|
Average | Displays the average of the two member values. |
Minimum | Displays the smaller of the two member values. |
Maximum | Displays the larger of the two member values. |
Median | Displays the median of the two member values. |
Aggregate | Aggregate displays the aggregate value of the members. This value is affected by whether a member has a C: level rule (a rule that applies to consolidated cells) associated with it or not. If the member has no C: level rule associated with it, Aggregate displays the sum. If the member has a C: level rule, the resulting value is the same as the consolidated member aggregating the same members. To use this feature, you must have IBM® Planning Analytics version 2.0.9 or later. |
Member1 * Member2 | Displays the product of Member 1 multiplied by Member2. |
Member1+ Member2 | Displays the sum of Member1 and Member2. |
Member1 - Member2 | Displays the difference of Member1 minus Member2. You can click |
Member1 / Member2 | Displays the quotient of the Member1 divided by Member2. You can click |
Member1 % change from Member2 | Displays the percent change from Member1 to Member2. You can click |
Member1 % of Member2 | Displays the value of Member1 expressed as a percentage of Member2. You can click |
If three or more members are selected, you can choose from these calculations.
Calculation name | Description |
---|---|
Average | Displays the average all selected member values. |
Minimum | Displays the smallest all selected member values. |
Maximum | Displays the largest of all selected member values. |
Median | Displays the median of all selected member values. |
Sum | Displays the sum of all selected member values. |
Aggregate | Aggregate displays the aggregate value of the members. This value is affected by whether a member has a C: level rule (a rule that applies to consolidated cells) associated with it or not. If the member has no C: level rule associated with it, Aggregate displays the sum. If the member has a C: level rule, the resulting value is the same as the consolidated member aggregating the same members. To use this feature, you must have IBM Planning Analytics version 2.0.9 or later. |