Show TOC

Percentage Functions at RuntimeLocate this document in the navigation structure

Percentage Function %GT (Percentage of Grand Total)
General Rules for Percentage Function %GT at Runtime

At runtime, an input-ready formula with percentage function %GT(op), Percentage of Grand Total, can only really be input ready if the op Operand is input ready at runtime.

Note

For more information about general rules on how the "non-input ready" characteristic is inherited for subtotals, totals and hierarchy nodes, see SAP Note 994853 Information published on SAP site.

Example

For a detailed explanation of the rules, see the discussion of example 6, Percentage of Grand Total in Examples: Inverse Formulas at Runtime.

Calculating the %GT Percentage Function in New Rows

The system also calculates inverse formulas in new rows. This results in changed values in the basic key figures: If rows already existed before, the system adds the changed values to the existing ones. There are no special checks for new rows.

Percentage functions %XT (Scale to Result Along the Columns) and %YT (Scale to Result Along the Rows).
General Rules for Percentage Functions %XT and %YT at Runtime

Functions %XT and %YT can be used in the same clients as %GT. %XT(op), %YT(op) are only input ready if the operand op is input ready.

Functions %XT and %YT calculate the percentage based on the next total level on the X or Y axis.

Note

If a BW hierarchy is used on the X or Y axis, the formula calculates the percentage of the operand on the root node of the hierarchy and does not take into account the next parent node in the hiearchy.

In the following cases, the system revokes the input-readiness of percentage functions %XT and %YT:
  • A hierarchy is used in the affected axis, i.e. function %XT is used at the same time as a hierarchy on the X axis, function %YT is used at the same time as a hierarchy on the Y axis.
  • Subtotals are suppressed in the result set of queries that are however required for calculation of the percentage functions.

If the value in cell %XT(op) is changed, the system takes over the changed percentage and calculates the new value of op based on the next total level value of op on the X axis. The system also fixes the value of the subtotal in order to ensure that the changed percentage is retained after a server roundtrip. The system also performs the calculations for changed %YT values accordingly.

Calculating Percentage Functions %XT and %YT in New Rows

In new rows, functions %XT and %YT are not input ready. Whether or not the corresponding cells can be displayed as non input-ready depends on the client.

Restriction

Some versions of Query Designer might generate error messages if no inverse formulas have been defined for the operands of %XT and %YT. The user does not need to define an inverse formula. The system creates one automatically. You can delete the corresponding placeholder of the inverse formula and save the query. If there are no further genuine errors in the query definition, the query is generated.