Start of Content Area

Function documentation Percentage Functions  Locate the document in its SAP Library structure

Use

You use the following percentage functions as operators when you define a formula or a calculated key figure.

Features

Note

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 Variance (%)

      <Operand1> % <Operand2>

This gives the percentage variance between operand 1 and operand 2. It is identical to:

Formula 100 * (<Operand1> - <Operand2>) / abs(<Operand2>) , if <Operand2> is not equal to 0 and the character for “Division by 0” if <Operand2> is equal to 0.

Example

Plan Sales % Actual Sales specifies the percentage difference between the plan sales and the actual sales.

Percentage Share (%A)

      <Operand1> %A <Operand2>

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

Character for "Division by 0" :See SAP Reference IMG SAP Customizing Implementation Guide SAP NetWeaver Business Intelligence Settings for Reporting and Analysis General Settings for Reporting and Analysis Display of Numeric 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 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 in both the rows and the columns, this reference is not unique. The system displays a warning and the relevant symbol for Data Does Not Exist. For more information, see SAP Reference IMG SAP Customizing Implementation Guide SAP NetWeaver Business Intelligence Settings for Reporting and Analysis General Settings for Reporting and Analysis Display of Numeric Values in the Business Explorer.

Example Table for Operator %CT <Operand>

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 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 were not specified in the Query Designer) also play a role in calculating the overall result.

Example Table for Operator %GT <Operand>

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 Query Result (%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 for 1999

60

33.3333

Overall result

 

60

66.6667

The year 1999 is in the dynamic filter. The 100% refers to the sales (180) not visible in the table (including the year 2000) (see %GT).

 

 

End of Content Area