Combining Rows

(1) Share

Report

Posted on by BM-23072014-0

Hello all,

I'm needing help with how to combine rows to have it return one value in a gallery.

I'm building an app for award nominations. In the app anyone can nominate anyone else, but only the senior team can score the nominations. There are 10 senior team members. The issue I ran into is if Person A nominates the same person as Person B, the nominee shows up twice. My goal is to combine rows that have the same nominee's name, then show the scores from each senior team member and add them together so no one has to go in and manually add up the scores.

The name of the Sharepoint list I am using is 'ABCD Scoring' with columns 'Nominee' for the nominee name, 'Senior Member' for the senior member name, then a column for each criteria the senior team scores.

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (1)

Report
Combining Rows

Hi BM-23072014-0,

Can you try the following please.

ClearCollect(finalScore, AddColumns( GroupBy('ABCD Scoring', "Nominee","subgroup"), "SumA", Sum(subgroup,CriteriaA), "SumB", Sum(subgroup,CriteriaB), "SumC", Sum(subgroup,CriteriaC) ) );

This should give you a list of Distinct winners with aggregated score.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like (0)

Report

Combining Rows

Hi,

Following up to check if you were able to solve this issue using my suggestion?

Kind regards,
Nandit

Was this reply helpful? Yes No