Show TOC

To calculate a new measure based on available measuresLocate this document in the navigation structure

Procedure

  1. 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.
  2. Choose Start of the navigation path Calculations Next navigation step Add Calculation Next navigation step [Operator] End of the navigation path.
    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.