Skip to Content
0

Aggregation Behaviour in calculation View

Nov 03, 2017 at 08:52 AM

54

avatar image
Former Member

Hi Experts,

I am facing some strange aggregation behavior while aggregating on one of the measure in data preview of calculation view. I have data in the backend with the highest granularity at document number and when I pull document number (BACDOCNR), I see desired results. But we have a requirement to expose the data without document number.

If I pull out the document number from output, amounts are not getting properly aggregated. Please find attached screenshots for details. When document number is excluded from output it should show value of BGWRBTR_1 -15,000,000 in the first row and -6,000 in the second row but it is displaying -capture1.png10,000,000 and -4,000 respectively.

Kindly advise if this is the right aggregation or if I am missing anything over here. Appreciate your expert help on this. Thanks.

Regards

Vishal

capture1.png (42.9 kB)
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Experts,

PFB the screenshot:

Regards

Vishal

capture1.png (42.9 kB)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Nov 03, 2017 at 09:24 AM
0

That's well known and documented behaviour. I recommend checking the SAP notes and the documentation.

Share
10 |10000 characters needed characters left characters exceeded