Percentage Functions
You can use the following percentage functions when defining a formula or a calculated measure as an operator.
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 Deviation (%)
- <Operand1> % <Operand2>
Indicates the percentage deviation between Operand1 and Operand2. This is identical to:
Formula 100 * (<Operand1> - <Operand2>) / abs(<Operand2>), if <Operand2> is not equal to 0, and the error value for 'Division by 0' if <Operand2> is equal to 0.
Tip'Planned Sales' % 'Actual Sales' specifies the percentage by which the actual sales exceeds the planned sales.
Percentage Amount (%A)
- <Operand1> %A <Operand2>
Indicates what percentage Operand1 is of Operand2. Identical to the formula 100 * <Operand1> / abs(<Operand2>) if <Operand2> is not equal to 0, and to the error value for 'Division by 0' if <Operand2> equals 0.
Error value for 'Division by 0': See SAP Reference IMG → SAP Customizing Implementation Guide → SAP NetWeaver → SAP NetWeaver Business Warehouse → Settings for Reporting and Analysis → General Settings for Reporting and Analysis → Display of Numeric Values in Business Explorer.
Tip'Fixed Costs' %A 'Costs' specifies how high the fixed cost part is of a product total cost.
Percentage of Total of Result (%CT)
- %CT <Operand>
Indicates how high the percentage amount is with regard to the result. Result here means the result of the aggregation at the next-highest level (intermediate 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 error value for 'Data Does Not Exist'. See SAP Reference IMG → SAP Customizing Implementation Guide → SAP NetWeaver→ SAP NetWeaver Business Warehouse → Settings for Reporting and Analysis → General Settings for Reporting and Analysis → Display of Numeric Values in Business Explorer.
Example Table for Operator %CT <Operand>
| Year | Region | Sales | %CT 'Sales' |
|---|---|---|---|
1999 |
North |
30 |
50 |
South |
30 |
50 |
|
Result 1999 |
60 |
33,3333 |
|
2000 |
North |
60 |
50 |
South |
60 |
50 |
|
Result 2000 |
120 |
66,6667 |
|
Overall Result |
180 |
100 |
Percentage of Grand Total (%GT)
- %GT <Operand>
Indicates what percentage the amount is of the grand total. Grand total here means the result of the aggregation at the highest level of the list. Dynamic filters (filters not already defined in Query Designer) are also included in the calculation of the grand total.
Example Table for Operator %GT <Operand>
| Year | Region | Sales | %GT 'Sales' |
|---|---|---|---|
1999 |
North |
30 |
16,6667 |
South |
30 |
16,6667 |
|
Result 1999 |
60 |
33.3333 |
|
2000 |
North |
60 |
33,3333 |
South |
60 |
33,3333 |
|
Result 2000 |
120 |
66,6667 |
|
Overall Result |
180 |
100 |
Percentage of Total of Query Total (%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 1999 |
60 |
33,3333 |
|
Overall Result |
60 |
66,6667 |
The year 1999 is in the dynamic filter. 100% refers to the sales figure 180 that cannot be seen in the table (including year 2000) (see %GT).
Percentage Amount with Signed Base Value (%_A)
- <Operand1> %_A <Operand2>
Indicates what percentage Operand1 is of Operand2. Identical to the formula 100 * (<Operand1> - <Operand2>) / (<Operand2>) if <Operand2> is not equal to 0, as well as with the error value for 'Division by 0' if <Operand2> equals 0.
Error value for 'Division by 0': See SAP Reference IMG → SAP Customizing Implementation Guide → SAP NetWeaver → SAP NetWeaver Business Warehouse → Settings for Reporting and Analysis → General Settings for Reporting and Analysis → Display of Numeric Values in Business Explorer.