Skip to Content

How to add two row values if conditions meet?

Hello All,

I want to add up two rows values into one if existed values in the specific column are same. Here is an example:

In the provided example, run 605 has two records, one with 605 and the other with 605BD, but the operator name is same. I want to display it in one row so the new row shows the aggregated values like operating hours equal to 4.83 (2.83+2.00) and service hours is equal to 5 (3+2). Please advise. I will appreciate your help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 02, 2017 at 07:54 PM

    You can:

    1. Group by the name field

    2. Suppress the Details section

    3. Add Group Summary to the Group Footer section

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 03, 2017 at 04:25 PM

    I see the problem: your report is already Groupped by the ID and you need to add the Name Group to higher level, in your case to Group 2.

    But in this case the Sorting will be changed. See the modified report I uploaded. Not sure if the new sorting could be acceptable solution.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Vitaly,

      Thank you for your time. I really appreciate your help. I am ok with the sorting order but I want to have only one line. For an example; Operator Michael Kelete has two lines. Can we have only one row in such cases?

  • Oct 03, 2017 at 04:39 PM

    Yes, you need to suppress the Group Header 3, add summaries to Group Footer 2, move the Group 3 name to Group Footer 2, then suppress Group Footer 2. And you will get only one line per name.

    Add comment
    10|10000 characters needed characters exceeded