calculating jquery datatable column

Question

inside jquery datatable I'm using sum plugin in order to sum values from particular column

 $('#example').DataTable( {
    drawCallback: function () {
      var api = this.api();
      $( api.table().footer() ).html(
        api.column( 4, {page:'current'} ).data().sum()
      );
    }
  } );

How can use this api call to calculate another column (for example column 6).

$( api.table().footer() ).html(
    api.column( 4, {page:'current'} ).data().sum()
    // calculate column 7 
);

also calculate result is injected inside first column of the footer instead of 4.

annoyingmouse · Accepted Answer · 2017-01-19 11:53:40Z

1

You were nearly there but your reference to api.table().footer() got the whole footer. To target specific column footers you need to use api.column(?).footer(). That way your issue should be addressed like this:

$(api.column(4).footer()).html(
  api.column(4, {
    page: 'current'
  }).data().sum()
);
$(api.column(6).footer()).html(
  api.column(6, {
    page: 'current'
  }).data().sum()
);

Here's a working example, hope that helps.

answered Jan 19, 2017 at 11:53

annoyingmouse

5,6991 gold badge31 silver badges48 bronze badges

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

1 Comment

annoyingmouse Over a year ago

There was mention of totaling durations. I've updated the JSFiddle with a solution which uses momentJSs duration (momentjs.com/docs/#/durations) object.

Collectives™ on Stack Overflow

calculating jquery datatable column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related