advancedCalculations.js

// Math summation on columns
var myClasses= "column_one, column_two, column_three"; //give your columns key, you can use multiple by using comma
var totalText = "Total: "; // you can change the 'Total' text here



if(!$table.find('tfoot').length){
    jQuery("<tfoot></tfoot>").appendTo($table);
}

function getSum(classes)
{
    var sum = 0;
    var index = 0;
    $table.find("."+classes+"").each(function() {
        var val = $.trim( $(this).text() );
        if ( val ) {
            val = parseFloat( val.replace( /^$/, "" ) );
            sum += !isNaN( val ) ? val : 0;
        }
    });
    index +=  jQuery("."+classes+"").index()+1;
    return [sum, index];


}
getSum();


function renderTfoot(){
    var counts = $table.find(".footable-header th").length;
    var num = parseInt(counts);
    var container = $("<tr class='final_result' />");
    var notThis = [];
    jQuery('.footable-header th').each(function(){
        if(jQuery(this).css('display') == 'none'){
            var index = parseInt(jQuery(this).index(),10) + 1;
            notThis.push(index);
        }
    }) 
    for(var i = 1; i <= num; i++) {
        if ($.inArray(i, notThis) != -1)
        {
         i;
        }
        else{
        $('<td />', {
            id: "id" + i,
            name: "name" + i
        }).appendTo(container);}
    }

    $('tfoot').prepend(container);
}



function setSumAmount() {
    var substr = myClasses.split(',');
    $.each(substr , function(index, val) {
        var singleClass = "ninja_clmn_nm_"+val.trim();
        $table.find('tfoot .final_result td#id'+getSum(singleClass)[1]+'').html(totalText + getSum(singleClass)[0] );
        
        function responisveChanges(){
            if(jQuery('th.'+singleClass).css('display') == 'none'){
                $table.find('tfoot .final_result td:nth-child('+getSum(singleClass)[1]+')').hide();
            }
            else{
                $table.find('tfoot .final_result td:nth-child('+getSum(singleClass)[1]+')').show();
            }
        }
        responisveChanges();

        jQuery(window).on('resize', function(){
            responisveChanges();
        });
    });
}
setSumAmount(renderTfoot(), getSum());

$table.on('after.ft.filtering', function() {
    setSumAmount();
});
$table.on('after.ft.paging', function() {
    setSumAmount();
});

Hi, great code i'm using it for Ninja Table Press Pro, Is there a way i can change the code slightly to calculate the column using time ie using multiples of 60 to show total time calculation?

Hi, any advice on how to limit the decimal numbers, please?