Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Change aggregation pattern.

Hi Guys,

here is the scenario I am working with. The data in my dataprovider is in the following format.

Doc no. Line Item Processing no Amount1 Amt 2

12345 1 1 10000 2000

12345 1 2 10000 3000

12345 2 1 8000 5000

Expected Results

Doc No. Amt 1 Amt2

12345 18000 10000

Please note that the requirement is that "Amount1" should not be aggregated across the Processing no. i.e. the 2 records with the same Doc no. and Line Item should give me an aggregate result of 10000 and not 20000 but when the Line Item changes, the values should be aggregated. Amt 2 is not an issue as they are all aggregated.

Suggestions on how to achieve this is highly appreciated,

Regards,

Doniv

Not what you were looking for? View more on this topic or Ask a question