doc-50182.pdf
TRANSCRIPT
![Page 1: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/1.jpg)
Generated by Jive on 2015-05-09+02:001
How to use Percentage Functions in BexQuery Designer
Percentage functions in BEx query designer are used to calculate different types of percentagesas per the business requirement of the report. These functions are used in calculated key figures/formulas of the query to calculate and display various percentage values with the symbol ‘%’ as asuffix.
Here is a business scenario of a BEx report in which all percentage functions available in BEx are used to
achieve the desired result ->
Screenshot of the Report in BEx Analyzer (Fig: 1) ->
Screenshot of the corresponding query in BEx Query Designer (Fig: 2) ->
![Page 2: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/2.jpg)
How to use Percentage Functions in Bex Query Designer
Generated by Jive on 2015-05-09+02:002
Theabove report deals with the sales of different stores in different countries during april and maymonths.Hence ‘Country’ , ‘Store Name’ characteristics are used as rows and KF selections ‘AprilSales’, ‘May Sales’ are used as columns in the report. Formula ‘Total Sales’ is nothing but the sumof ‘April Sales’, ‘May Sales’.
1. Using ‘Percentage Variance (%)’ function:
![Page 3: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/3.jpg)
How to use Percentage Functions in Bex Query Designer
Generated by Jive on 2015-05-09+02:003
Calculation behind this formula:
‘April Sales’ % ‘May Sales’ = 100 (April Sales – May Sales) / abs (May Sales), when denominatornot equals zero.If denominator equals zero, then based on your BEx global settings, it displaysthe character you set for ‘division by 0’operations.For example: #, X, blank space, 0 etc.
In (Fig: 1) -> % variance between ‘April Sales’, ‘May Sales’ is calculated as highlighted below:
![Page 4: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/4.jpg)
How to use Percentage Functions in Bex Query Designer
Generated by Jive on 2015-05-09+02:004
2. Using ‘Percentage Share (%A)’ function:
![Page 5: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/5.jpg)
How to use Percentage Functions in Bex Query Designer
Generated by Jive on 2015-05-09+02:005
Calculation behind this formula:
‘April Sales’ %A ‘Total Sales’ = 100 (April Sales) / abs (Total Sales), when denominator not equalszero. If denominator equals zero, then based on your BEx global settings, it displays the characteryou set for ‘division by 0’operations.For example: #, X, blank space, 0 etc.
In (Fig: 1) -> % share of ‘April Sales’ in ‘Total Sales’ is calculated as highlighted below:
![Page 6: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/6.jpg)
How to use Percentage Functions in Bex Query Designer
Generated by Jive on 2015-05-09+02:006
3. Using ‘Percentage Share of Result (%CT)’ function:
![Page 7: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/7.jpg)
How to use Percentage Functions in Bex Query Designer
Generated by Jive on 2015-05-09+02:007
Calculation behind this formula:
%CT ‘Total Sales’ means -> Percentage share of ‘Total Sales’ values in ‘Result’ values of theReport.
From (Fig: 1) -> % share of ‘Total Sales’ values in ‘Result’ values of the Report are calculated ashighlighted below:
![Page 8: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/8.jpg)
How to use Percentage Functions in Bex Query Designer
Generated by Jive on 2015-05-09+02:008
4. Using ‘Percentage Share of Overall Result (%GT)’ function:
![Page 9: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/9.jpg)
How to use Percentage Functions in Bex Query Designer
Generated by Jive on 2015-05-09+02:009
Calculation behind this formula:
%GT ‘Total Sales’ means -> Percentage share of ‘Total Sales’ values in ‘Overall Result’ values ofthe Report.
From (Fig: 1) -> % share of ‘Total Sales’ values in ‘Overall Result’ values of the Report arecalculated as highlighted below:Fig: 3 ->
![Page 10: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/10.jpg)
How to use Percentage Functions in Bex Query Designer
Generated by Jive on 2015-05-09+02:0010
5. Using ‘Percentage Share of Query Result (%RT)’ function:
![Page 11: DOC-50182.pdf](https://reader033.vdocuments.us/reader033/viewer/2022051417/55cf8e3c550346703b8ffc78/html5/thumbnails/11.jpg)
How to use Percentage Functions in Bex Query Designer
Generated by Jive on 2015-05-09+02:0011
Calculation behind this formula:
There is no difference between functionality of %GT, %RT functions when the report does not have any
dynamic filter applied (as shown in Fig: 3 above).
But when a dynamic filter is applied, ‘Overall Result’ values in the report are changed inaccordance with the filter value. Hence %GT function calculates % share values by consideringchanged ‘Overall Result’ values.
Here comes the importance of %RT function, this percentage function will always calculate% share values with respect to the ‘Query Result’ (i.e., ‘Overall Result’ before the filter wasapplied),which means %RT function works irrespective of the dynamic filter and the querynavigational state.
When a dynamic filter is applied on the report, the difference in functionality of the %GT, %RT functions can be
observed in the Fig: 4 below.
Note: dynamic filter is applied on the ‘Country’ column with value ‘BR Brazil’.
Fig: 4 ->