Percentage Functions (SAP Library - Enterprise Reporting, Query, and Analysis)

Percentage Functions

Use

These are functions that you can use as operators for defining a formula or a calculated key figure.

Features

Percentage Deviation (%)

<Operand1> % <Operand2>

This gives the percentage deviation between operand 1 and operand 2. It is identical to the formula
100 * (<Operand1> - <Operand2>) / abs(<Operand2>) , if <Operand2> does not equal 0 and the character for “Division by 0” if <Operand2> equals 0.

Example

Plan Sales % Actual Sales, expresses the difference between the plan sales and the actual sales as a percentage.

Percentage Share (%A)

<Operand1> %A <Operand2>

This gives the percentage share of operand 1 and operand 2. It is identical to the formula
100 * <Operand1> / abs(<Operand2>) , if <Operand2> does not equal 0 and the character for “Division by 0” if <Operand2> equals 0.

Character for “Division by 0”: See SAP Reference IMG ® Business Information Warehouse ® Reporting-relevant Settings ® General Reporting Settings ® Display of Numerical Values in the Business Explorer.

Example

Fixed Costs %A Costs expresses the proportion of the total cost of a product that is the fixed cost.

Percentage Share of the Result (%CT)

%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 upon in both the rows and the columns, this relationship is not unique, causing the system to display the warning, and relevant symbol for Data does not exist. See SAP Reference IMG ® Business Information Warehouse ® Reporting-relevant Settings ® General Reporting Settings ® Display of Numerical Values in the Business Explorer.

Example

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

Percentage Share of the Overall Result (%GT)

%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 have not been determined already in the query definition) also play a role in calculating the overall result.

Example

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

Percentage Share of the Query Result (%CT)

This is much the same as %GT.

Note

Unlike the process of calculating the overall result, dynamic filters are not used in the calculation of the query result. This means that, independently of the filter status and the navigational state, the same value is always normalized.