Sum columns

measterbrook

Is there an add-in that allows the columns to be summed, either at the top or bottom of the table?

kthorngren

This example should help:
https://datatables.net/examples/advanced_init/footer_callback.html

Kevin

colin

This sum plugin could be useful too.

measterbrook

Actually I used:

"initComplete": function (settings, json) {
            this.api().columns('.sum').every(function () {
                var column = this;

                var sum = column
                   .data()
                   .reduce(function (a, b) {
                       a = parseInt(a, 10);
                       if (isNaN(a)) { a = 0; }

                       b = parseInt(b, 10);
                       if (isNaN(b)) { b = 0; }

                       return a + b;
                   });

                $(column.footer()).html(sum);
            });
        }
    });