You use the following percentage functions as operators when you define a formula or a calculated key figure.
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.
● <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.
● <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 Warehouse → Settings for Reporting and Analysis → General Settings for Reporting and Analysis → Display of Numeric Values in the Business Explorer.
Fixed Costs %A Costsexpresses the proportion of the total cost of a product that is the fixed cost.
● %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 Warehouse → 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 |
● %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 |
● %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).