Percentage Share and Percentage Share with Signed base value
This document focuses in explaining the difference between the “Percentage Share” and “Percentage Share with the Signed base value” operands present in the Business Explorer and to how to use it in BEX.
Percentage Share (%A): <operand 1> %A <operand 2>
This gives the percentage share of operand 1 and operand 2. It is identical to formula (<operand 1> / abs(<operand 2>) )*100
Percentage share with Signed base value (%_A): <operand 1> %_A <operand 2>
This gives the percentage share of operand 1 and operand 2. It is identical to formula ( <operand 1> / <operand 2> )*100
This is available under Percentage Functions in Query Designer:
How to Apply:
Formula with %A:
This is percentage share between JAN Budget data to Actual data.
Formula with %_A:
Output from the BEX with %A and %_A:
Where ever the actual amount is negative, %A is giving the data in Positive due to the ABS function usage where as %_A is giving the result without ABS. Developer has to choose depending on the requirement from the Customer. Few customers are interested to use the %A to show the result in Positive always when the denominator is in Negative.
The operators are maintained in the table RSZOPRATOR and RSZOPRATXT.
RSZOPRATXT is used to maintain the text information of the operator.
To activate this operator, use transaction SE16, select the %_A operator in the RSZOPRATOR table, go to ‘Table entry and then Create with template’ and replace the Object version entry from X with an A.
With this the %_A is available in the frontend layer and can be used in BEX for calculations.
If the operator %_A is not present in table RSZOPRATOR then use %A entry as template and then make an entry for %_A and version with A and define a text for %_A in the table – RSZOPRATXT to display the text in front end.