how to get sum of a column in sharepoint 2013 list

Question

Not sure if i would get any answer from here. I have a column number and title text. The data would look like this:

Title  Paid
----------
Jacob  200
Patrick 100
Jacob   100
Patrick 300

What i would like to get is

Jacob: 300
Patrick 400

I was thinking of using a workflow and write the data to another list

Thanks in Advance if anyone has an idea

Answer 1

• 2010/2013 No code: Set your view to Group By Title and Sum the Paid Column

• 2013 CSR (Client Side Rendering) code: UseOnPreRender to loop through the items

• 2010/2013 Calculated Column: Sum Calculated Column (SP 2013)

(Works in Group View)

Full explanation at: https://www.365csi.nl/vm365com/#/Create/Sum

Answer 2

See if this helps:

SharePoint List: Find Sum, Average on the values with Group By https://rmanimaran.wordpress.com/2011/05/21/sharepoint-list-find-sum-average-on-the-values-with-group-by-3/

Answer 3

Client Side Rendering

As DannyEngelman mentioned, you can use CSR for SharePoint 2013. Following snippet may help. I have tested it in OnPreRender

var newValues = [];

ctx.ListData.Row.forEach(function(item) {
    var isDuplicate = newValues.filter(v => v.Title == item.Title);
    if (isDuplicate.length == 0) {
        var hasSameTitle = ctx.ListData.Row.filter(v => v.Title == item.Title);
        var itemsSum = hasSameTitle.reduce((a, b) => parseFloat(a["Paid."]) + parseFloat(b["Paid."]));
        item["Paid"] = itemsSum;
        newValues.push(item);
    }
});

ctx.ListData.Row = newValues;

PS: Not sure IE has support for Arrow functions yet. If it does not have, then you can use callback.