Show TOC

# Percentage Functions Use

You can use the following percentage functions when defining a formula or a calculated key figure as an operator.

Features

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.

Example

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).