Procedure
- Select the measure headings that you
want to use.
The first measure that you
select is the first operand. Use the
STRG key to
select the next measure that is the second operand. You can also select more
than two operands for your calculation.
- Choose
.
The following operators are
available:
- Add
- Substract
- Multiply
- Divide
- Percentage Difference
The new measure calculates the difference
between operand 1and operand 2 as a percentage.
For example, operand 1 has value 80 and
operand 2 has value 20. The new measure displays the value 300%, as the
difference is 60 and 60 is 300% of 20.
If operand 2 has a higher value than operand
1, the result is negative. For example, operand 1 has value 20 and operand 2
has value 80. The new measure displays the value -75%, as the difference is -60
and -60 is -75% of 80.
- Percentage Share
The new measure calculates the share of
operand 1 in comparison with operand 2 in percentage.
For example, operand 1 has value 20 and
operand 2 has value 80. The new measure displays the value 25%, as 20 is 25% of
80.
Results
The new calculated measure is added to the crosstab
and the design panel.
A measure value that is displayed with sign reversal, is used in calculations as displayed.
Example A measure value is 200. If you have selected the sign reversal
property in the BEx query definition, the value is displayed as -200 in
Analysis. For calculations in Anaylsis, the value 200 is used. If you select
this check box, the value -200 is used for calculations.