Skip to main content

Notifications

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

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

Posted on by 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.

pastedimage1679022906927v1.png

Is there is any way to do this.

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,051 Super User 2024 Season 1 on at
    RE: How to Combine Duplicate Rows and Sum the Values in Business Central.

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans