DataTables: total a column - except for rows with specific class?

Question

I have the code to total a column, but I have subgroups that already have totals. Can I total each number in the column EXCEPT the gray total rows?

var table = $('#datatable');
var leng = table.find("tr:first").children().length;

    // add totals to new row
            for (var i = 0; i < leng; i++) {

                var total = api
                .column(i)
                .data()
                    .reduce(function (a, b) {
                        // return if it's not a value from the gray row
                        return intVal(a) + intVal(b);
                    });

                // correct any html mistakes that slip through
                if (isNaN(intVal(total)))
                    total = '';

                table.find("tfoot tr:first th").eq(i).html(total);
            };

They do, but how would that look code wise? The class is 'sgrouptotal' — triplethreat77
– triplethreat77, Commented Sep 4, 2015 at 12:43
use .not('.sgrouptotal') to exclude everything that have class sgrouptotal — J Santosh
– J Santosh, Commented Sep 4, 2015 at 16:13

davidkonrad · Accepted Answer · 2015-09-04 15:58:44Z

2

Why not just use the :not selector on the rows() API method and calculate the sum based on the remaining rows? Very small example, add the sum of col#1 to the footer in a callback :

var table = $('#example').DataTable({
    drawCallback: function () {
        var api = this.api(),
            sum = 0;
        api.rows(":not('.sgrouptotal')").every(function() {
            sum += parseFloat(this.data()[0]);
        });    
        $(api.column(0).footer()).text(sum);
    }
});

demo -> http://jsfiddle.net/j38bmagj/

The above should be fairly easy to extend to multiple columns. Calculate the sum for col #4 in the same loop like sum4 += this.data()[4] and so on.

answered Sep 4, 2015 at 15:58

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Velimir Tchatchevsky · Accepted Answer · 2015-09-04 13:19:19Z

0

What about just doing that?

i = 0;          
$('#datatable tr:first tr').each(function(key, value){
    if(!$(this).hasClass("sgrouptotal"){
        i += parseInt(value.text());
    }
});

edited Sep 4, 2015 at 13:19

answered Sep 4, 2015 at 12:53

Velimir Tchatchevsky

2,8401 gold badge18 silver badges21 bronze badges

1 Comment

triplethreat77 Over a year ago

This doesn't work because i refers to the columns, of which there is 4 - not the 12 rows.

Collectives™ on Stack Overflow

DataTables: total a column - except for rows with specific class?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related