SharePoint 2013 How to calculate results from sum of two columns

Question

Instead of using the predefined total options(sum, count, average, maximum, minimum, stdev) I would like to create my own formula and place it in a similar position. Here is a picture of what I was referencing.

What I would like to do is perform a calculation based on two columns and their sums to generate a new result.

In excel it looks like this: =SUM(F13:F17)/(Sum(D13:D17)*3).

Basically, I just want the sum of two entire columns, do some simple division and multiplication, and generate a new result.

If I could place this result above like the predefined totals that came with SharePoint that would be great or somewhere else works. I just need this result to appear somewhere in the list.

Any help is appreciated, thank you!

Edit: In a calculated column, how do I select more than just 1 row? I would like to select all of the rows.

Answer 1

All answers in this topic skin the cat

The non-Designer, non-JSlink, non-Data View WebPart way

By whacking some HTML & JavaScript in a Calculated Column

You can get this:

Not suggested for large volume lists, but fine for Views that fit in your display.

Note: It only displays in View, it is not a new Fied value you can continue with

Takes 9 steps and some 15 minutes (or 2 if you just copy/paste the last step)

See: http://www.viewmaster365.com/#/Create/Sum

Answer 2

You can do this by creating a JSLink file and attaching it to the List View webpart using the webpart properties pane.

Inside the JSLink file you can use somethhing like below

var _totalValue1 = 0.0;
var _totalValue2 = 0.0;
(function () {
    var calculatedFieldCtx = {};       
    calculatedFieldCtx.Templates = {};   
    calculatedFieldCtx.Templates.Fields = {
        "FieldOne": {
            "View": Calculated1
        },
        "FieldTwo": {
            "View": Calculated2
        }
    };   
    calculatedFieldCtx.OnPostRender = [];
    calculatedFieldCtx.OnPostRender.push(function()
    {
        var result = _totalValue1 + _totalValue2 / 3;
        alert(result);
    });
    SPClientTemplates.TemplateManager.RegisterTemplateOverrides(
        calculatedFieldCtx
    ); 
})();


function Calculated1(ctx) {       
    _totalValue1 += parseFloat((ctx.CurrentItem.FieldOne));
    return ctx.CurrentItem.FieldOne;
}

function Calculated2(ctx) {       
    _totalValue2 += parseFloat((ctx.CurrentItem.FieldTwo));
    return ctx.CurrentItem.FieldTwo;
}

Answer 3

You can use calculated column in that case.

• For the Total you can edit in the View - Total Scores - Select the Calculated Column.

Answer 4

Mark Rackley posted a very good explanation of how to do this with SharePoint Designer.

Basically, you use a Data View Web Part to display your information and you can customize the look to show your formulated total.