web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to Combine Duplica...

Small and medium business | Business Central, N...

Suggested Answer

How to Combine Duplicate Rows and Sum the Values in Business Central.

(0) Share

Report

Report

Posted on by Nilam Bhor

153

Hi Guys,

For example: I have 3 fields. i.e. no,description, quantity.

in my no field ,i have the duplicate values.& also description have same values.

I want ,that 2 same entry ,should i get in one entry.as shown in below image.i.e. result.

And that same entry have quantity also , so i want sum of that quantity as shown below image.

Is there is any way to do this.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Steven Renders 5,698 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

In a report, this can be done in the layout, by adding a group. For example group on the Number, and then calculate a Sum of the Quantity.

In a query, you can add the three fields as columns, and then calculate a Sum method on the Quantity. This will then add a group on the No and Description.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 647 Super User 2026 Season 1

#2

Gerardo Rentería Ga... 447 Most Valuable Professional

#3

YUN ZHU 366 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans