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.

Table 1. Single member calculation options
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 to reverse the order of the values, subtracting the member value from the specified numeric value.
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 to reverse the order of the values, dividing the specified numeric value by the member value.
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.

Table 2. Two members calculation options
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 to reverse the order of the values, subtracting Member1 from Member2.
Member1 / Member2	Displays the quotient of the Member1 divided by Member2. You can click to reverse the order of the values, dividing Member2 by Member1.
Member1 % change from Member2	Displays the percent change from Member1 to Member2. You can click to reverse the order of the values, displaying the percent change from Member2 to Member1.
Member1 % of Member2	Displays the value of Member1 expressed as a percentage of Member2. You can click to reverse the order of the values, displaying the value of Member2 as a percentage of Member1.

If three or more members are selected, you can choose from these calculations.

Table 3. Three or more members calculation options
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.