Sum duplicate values (Question)

[Former Member]

Hi SAP Community

Is it possible to sum the duplicate values in 515400 code? see image below. TIA

[raghavendra_hullur]

Hi,

Yes it's possible.

But, can you explain where you want to display the summed value? Do you have a group on code column or are you placing your fields in detail section?

If you have placed your fields in detail section, then you can insert a summary on your report footer on the field with values you have marked.

If you have a group on code, then insert summary at group footer for code, you can get summary for each code.

Please explain more in case you are looking for some other solution.

Thanks,

Raghavendra

[Former Member]

Hi

Thanks for the reply.

Report is already grouped. I just want to merge the summation in detail section also.thanks

Output should be like this

515400 Assignment Allowance  257,964.90 (sum of 3 x 85,988.30)

515400 Assignment Allowance  27,154.20

515400 Assignment Allowance  38,468.45

[abhilash_kumar]

Hi Jana,

Easiest way to do this:

1) Insert a group on the Amount field. If there are other groups then the amount group should be the last one

2) Go to Insert Summary > Choose the amount field as the Field to Summarize > Under Summary Location choose the Group footer for the Amount from the drop-down

3) Move all the fields (code, assignment allowance and the summary) to Group Footer of the Amount group

4) Suppress all other unwanted sections.

-Abhilash

[raghavendra_hullur]

Hi,

That's bit of strange requirement, but if you need it in that way, you may have to insert another group on your amount field and insert summary on the Amount field along with moving your fields from current section to the newly created group into group footer section.

Not sure though the format will be as expected by you.

Thanks,

Raghavendra