cancel
Showing results for 
Search instead for 
Did you mean: 

Reason for overall result and sum of the column not matching in SAP BEx

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

adam_bulat
Member
0 Kudos

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

former_member194898
Active Contributor
0 Kudos

Hi,

Remember that there's a possibility to define exception aggregation on a key figure level and in that way change method of counting values in result row.

Here:

Regards, Leszek

Former Member
0 Kudos

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