on 09-17-2014 12:32 AM
Hi Experts,
When i execute the report in BEx Analyzer, the overall result and sum of the column are not matching.
So I changed the Keyfigure property, Calculation result as "Sum". After changing the property in the report output, i am able to match the overall result and sum of the column.
Could you help me to understand why the overall result and sum of the column not matching in SAP BEx.
Thanks,
Suman
Hi,
There can be differences in rounding between detailed values and sum. You can change number of decimal places and then check full values.
Ex.
without rounding / with rounding
1,4 => 1
1,4 => 1
sum 2,8 => 3
Sometimes it's not able to see full values in a query, so you shoud check values in a InfoProvider.
More info about decimal places configuration in queries is here.
Regards,
Adam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suman,
The KF you are using might be based on some formula.
Suppose There are column A, B, C and D = (A+B)/C.
By default Overall Result of D will be ∑(A+B)/C. Where as we expect it as (∑A+∑B)/∑C. We need to specify calculate result as "SUM" to get the correct result.
Regards,
SBABAR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.