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