Percentage Functions
Use
You can use the following percentage functions when defining a formula or a calculated measure as an operator.
Features
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.
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 Business Warehouse → Settings for Reporting and Analysis → General Settings for Reporting and Analysis → Display of Numeric Values in Business Explorer.
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'. 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 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.
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 of the Result Along the Columns (%XT) and Percentage Amount of the Result Along the Rows (%YT)
These functions calculate the percentage of the operand, taking into account the next higher subtotal on the X (column) axis or on the Y (row) axis.
In the context of BW Integrated Planning, you can create formulas - in input-ready queries - by using these operators, in order to scale to the result. The formulas do not relate to the grand total however (like %GT does). They relate to the next total level on the X or Y axis instead.
Percentage Amount with Signed Base Value (%_A)
<Operand1> %_A <Operand2>
Indicates what percentage Operand1 is of Operand2. Identical to the formula 100 * <Operand1> / (<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 Business Warehouse Settings for Reporting and Analysis General Settings for Reporting and Analysis Display of Numeric Values in Business Explorer.