Percentage Functions
You can use the following percentage functions when defining a formula or a calculated key figure as an operator.
Operator |
Operator Name |
Description |
|---|---|---|
% |
Percentage Deviation |
<Operand1> % <Operand2> Specifies the percentage deviation of Operand1 to Operand2. Identical to the formula 100 * (<Operand1> - <Operand2>) / abs(<Operand2>) if <Operand2> is not equal to 0, as well as with the error value for 'Division by 0' if <Operand2> equals 0. |
%A |
Percentage |
<Operand1> %A <Operand2> Specifies the percentage amount of Operand1 to Operand2. Identical to the formula 100 * (<Operand1> - <Operand2>) / abs(<Operand2>) if <Operand2> is not equal to 0, as well as with the error value for 'Division by 0' if <Operand2> equals 0. |
%CT |
Percentage of Total |
%CT <Operand> Specifies 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). |
%GT |
Percentage of Total of the Grand Total |
%GT <Operand> Specifies how high the percentage amount is with regard to the grand total. Grand total here means the result of the aggregation at the highest level of the list. The dynamic filters (filters that were not already defined in the Query Designer) are also included in the calculation of the grand total. |
%RT |
Percentage of Total of Query Total |
%RT <Operand> The same as the percentage function %GT; In contrast to the calculation of the grand total, the dynamic filters are not included in the calculation of the query result, that is, it is always normalized to the same size, irrespective of the dynamic filter and navigation status. |
Percentage Deviation (%)
'Planned Revenue' % 'Actual Revenue' specifies the percentage by which the actual revenue exceeds the planned revenue.
Percentage Amount (%A)
'Fixed Costs' %A 'Costs' specifies how high the fixed cost part is of a product total cost.
Percentage of Total of Result (%CT)
Year |
Region |
Revenue |
%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 Total of the Grand Total (%GT)
Year |
Region |
Revenue |
%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)
Year |
Region |
Revenue |
%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. The 100% refers to the revenue 180 that cannot be seen in the table (including Jahr 2000) (see %GT).