Total of data column

Francois62

Hi,

I wonder if it's possible to calculate total of data column while filtering this.
Till now, I can calculate total but without filtering.
I want to have total of lines displayed.

Thank you in advance,
Regards,
François.

Francois62

NB : I use the 1.9.4 version!

allan

In 1.10 its a simple as:

var sum = table.column( 4 ).data().eq(0).reduce( function ( a, b ) {
  return a + b;
} );

In 1.9 take a look at this example: http://legacy.datatables.net/release-datatables/examples/advanced_init/footer_callback.html

Allan

Francois62

I found another solution to resolve my problem. I put it to help another person who have the same problem :-)

$(document).ready(function() {
    var oTable = $('#bordereau').dataTable( {
        fnFooterCallback: function ( nRow, aaData, iStart, iEnd, aiDisplay ) {
            var TotalMarks = 0;
            for ( var i=iStart ; i<iEnd ; i++ ) {
                console.log(TotalMarks, aaData[ aiDisplay[i] ][4].replace(',','.'));
                TotalMarks += parseFloat(aaData[ aiDisplay[i] ][4].replace(',','.'));
            }
            var nCells = nRow.getElementsByTagName('th');
            nCells[3].innerHTML = "Total = "+TotalMarks+" &euro;";
        }
    } );
} );

Thank you for your help!

Regards,

François