## Percentage Functions

### Use

You use the following percentage functions as operators when you define a formula or a calculated key figure.

### Features

NULL values are displayed as empty cells, not as 0. For more information about when NULL values occur and how they are displayed, see Technical Notes About the Formula Operators.

##### Percentage Variance (%)

<Operand1> % <Operand2>

This gives the percentage variance between operand 1 and operand 2. It is identical to:

Formula 100 * (<Operand1> - <Operand2>) / abs(<Operand2>) , if <Operand2> is not equal to 0 and the character for “Division by 0” if <Operand2> is equal to 0.

Plan Sales % Actual Sales specifies the percentage difference between the plan sales and the actual sales.

##### Percentage Share (%A)

<Operand1> %A <Operand2>

This gives the percentage share of operand 1 and operand 2. It is identical to formula 100 * <Operand1> / abs(<Operand2>) , if <Operand2> is not equal to 0 and the character for “Division by 0” if <Operand2> is equal to 0.

Character for "Division by 0" :See SAP Reference IMG SAP Customizing Implementation Guide SAP NetWeaver Business Intelligence Settings for Reporting and Analysis General Settings for Reporting and Analysis Display of Numeric Values in the Business Explorer.

"Fixed costs" %A "costs" expresses the proportion of the total cost of a product that is the fixed cost.

##### Percentage Share of Result (%CT)

%CT <Operand>

This shows how high the percentage share is, with regard to the result. The result is the outcome of aggregating the second highest results level (interim result).

If a characteristic has been drilled down in both the rows and the columns, this reference is not unique. The system displays a warning and the relevant symbol for Data Does Not Exist. For more information, see SAP Reference IMG SAP Customizing Implementation Guide SAP NetWeaver Business Intelligence Settings for Reporting and Analysis General Settings for Reporting and Analysis Display of Numeric Values in the Business Explorer.

Example Table for Operator %CT <Operand>

 Year Region Sales %CT ‘Sales’ 1999 North 30 50 South 30 50 Result for 1999 60 33.3333 2000 North 60 50 South 60 50 Result for 2000 120 66.6667 Overall result 180 100
##### Percentage Share of Overall Result (%GT)

%GT <Operand>

This shows how high the percentage share is with regard to the overall result. The overall result is the outcome of aggregating the highest results level. Dynamic filters (filters that were not specified in the Query Designer) also play a role in calculating the overall result.

Example Table for Operator %GT <Operand>

 Year Region Sales %GT ‘Sales’ 1999 North 30 16.6667 South 30 16.6667 Result for 1999 60 33.3333 2000 North 60 33.3333 South 60 33.3333 Result for 2000 120 66.6667 Overall result 180 100
##### Percentage Share of Query Result (%RT)

%RT <Operand>

This is the same as %GT.

Unlike the process for calculating the overall result, dynamic filters are not used in the calculation of the query result. This means that the calculation always normalizes to the same value, irrespective of the filter status and the navigational state.

Example Table for Operator %RT <Operand>

 Year Region Sales %RT 'Sales' 1999 North 30 16.6667 South 30 16.6667 Result for 1999 60 33.3333 Overall result 60 66.6667

The year 1999 is in the dynamic filter. The 100% refers to the sales (180) not visible in the table (including the year 2000) (see %GT).