Overall Result Row is not the Sum of Individual Values!

[Former Member]

I am frustrated with a weird problem. I have an expense report in which Expense1 is shown a value of 8,126. If I drilldown by company code, the sum of the company codes is 8,235, but the "Overall Result" row is showing 8,126.

I tried drilling down by GL accounts, cost centers, profit centers, material and even currency. For all of these drilldowns the "Overall Result" row is 8,126 but the individual values sum out to be 8,235.

First I thought it could be "Zero Suppression" that is hiding some values from the display. But "Zero Suppression" was not active at all. I have checked the LISTCUBE and saw that the Expense1 should be 8,235 and not 8,126. The key figure properties "Calculate Result As" and "Calculate Single Values As" are set to "Nothing Defined" and "Use Default Direction". But still for some strange reason, the "Overall Result" row is different than the sum of individual rows. It's driving me crazy as I have ran out of ideas to figure out what's happening. Could someone help me with this? I would appreciate any input with points!

[former_member188975 · Accepted solution]

Hi Sameer,

Can you attribute the value 109 (8235-8126) to anything...?

[Former Member · Accepted solution]

Bhanu, I have already went down that logical path but no use! I know it's a strange thing and I have made sure that I am not doing anything stupid. Do you know how SAP calculates "Overall Result" in a query?

Srini, it's definitely not data problem as I said in my post that LISTCUBE is giving me 8235 whereas the report is showing 8126!

Any more guesses guys?

[former_member188975 · Accepted solution]

Hi Sameer,

Have you tried forcing the "Calculate Result As" to Summation? What do you get now...?

[Former Member · Accepted solution]

Hi,

Remove the 'Suppress Zero rows/columns' from the query definition and then check the values.

Column A might have value, but for the same row column B might have zero, hence the row was not shown in the result set, but the overall result will include all such values as well, even thought it was not shown in the result set.

HTH,

regards,

Nataraj.

[Former Member]

Hi Sameer,

Did you find any resolution to the issue. We have a similar issue and after researching everywhere, I am still stuck.

Please let us know if there is a way out.

Thanks..

[Former Member]

Is this a calculated key figure or formula? If so check and see whether you get the value 8,126 when you do the calculations using the bse key figure values which is used in the calculations.

Thanks.

[former_member188325]

Hi ,

Just give a trial by creating a fomula with NODIM. i.e. NODIM(Expense1) and now check the overall result.i had a similar kind of problem and it was sloved by usimg NODIM function.

regards

[Former Member]

Hi Sameer,

Check againest the infoprovider. for the same selection(with all company codes ..& etc....). So u will know it is report problem or Data problem.

I think it is Data problem... not report problem.

Srini