Sum result giving wrong value

[revancpc123]

Hi Everyone,

So i'm using =sum function so the denomination values don't repetitive shown,

And when i use the sum function the result is overcalculated

Any views on this? is there any alternatives?

Thanks in advance.

Regards.

[AnnePetteroe]

Hello Revan,

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will also help you when preparing questions for the community.

By adding a picture to your profile you encourage your readers to respond.

Kind regards,
Anne

[nscheaffer]

It is always helpful to share the Qualification (e.g., Detail, Dimension, or Measure) of the object you are using.

My guess is your Amount is a Dimension. In that case, Web Intelligence will group duplicate values together. So I don't believe your Amount Total is overstated. Rather your details contributing to those totals are understated. Let me explain with a simple example.

Here is a free-hand SQL statement that should yield a total of 3,500 for ID ABC123 and 3,700 for ID XYZ789...

SELECT 'ABC123' AS [ID], 1000 AS [Amount]
UNION ALL SELECT 'ABC123', 1000
UNION ALL SELECT 'ABC123', 1500
UNION ALL SELECT 'XYZ789', 1200
UNION ALL SELECT 'XYZ789', 1200
UNION ALL SELECT 'XYZ789', 1300;

Here are my initial results with a break on ID and subtotals...

I created a variable named Var Total Amount with this formula...

=Sum([Amount])

This what I would expect given my free-hand SQL statement. However, it looks to be overstated given the values in the Amount column. The reason is that since Amount is Dimension duplicate values duplicate values are being suppressed.

You can see the full details by checking the "Avoid duplicate rows aggregation" in the properties of the table. If you are not yet on version BusinessObjects 4.3, you may have to hunt around to find this property.

So the totals were in fact not overstated, but the details were understated.

Noel

[revancpc123]

Hi Noel,

Thank you for the response i already tried your way but the result is the same

i already make a new question with the detail info

https://answers.sap.com/questions/13970112/how-to-sum-calculation-on-duplicate-rows.html

regards