calculate sum of two columns inside jquery datatables

Question

I have jquery datatable and I want to calculate sum of two columns. initialization of the table

 $('#myTable').DataTable({
        autoWidth: false,
        searching: false,
    ...
     initComplete: function (settings, json) {
        // calculate sum and inject into second and third row in the footer
     });
  });

<table id="myTable">
   <thead>
      <tr>
         <th>Id</th>
         <th>Time one</th>
         <th>Time two</th>
      </tr>
   </thead>
   <tfoot>
      <tr>
         <th></th>
         <th></th>
         <th></th>
      </tr>
   </thead>
</table>

Update:

vales inside this columns are like:

=====================
| 1 | 01:15 | 10:00 |
=====================
| 9 | 11:44 | 0:120

|

What exactly is your question? What problem did you encounter? — Alexandru Severin
– Alexandru Severin, Commented Jan 18, 2017 at 12:29
let me rephrase the question: I want total in the footer of the third column for example. — user1765862
– user1765862, Commented Jan 18, 2017 at 12:46

Kacper Polak · Accepted Answer · 2017-01-18 12:30:08Z

0

You can do it using DataTable Plugin API:

// Simply get the sum of a column
var table = $('#example').DataTable();
table.column( 3 ).data().sum();

// Insert the sum of a column into the columns footer, for the visible
  // data on each draw
  $('#example').DataTable( {
    drawCallback: function () {
      var api = this.api();
      $( api.table().footer() ).html(
        api.column( 4, {page:'current'} ).data().sum()
      );
    }
  } );

More: https://datatables.net/plug-ins/api/sum()

answered Jan 18, 2017 at 12:30

Kacper Polak

1,41115 silver badges24 bronze badges

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

5 Comments

GôTô Over a year ago

Not sure if OP wants the total or rather a new column containing the row by row sum

user1765862 Over a year ago

total in the footer.

Kacper Polak Over a year ago

So you can use this api.

user1765862 Over a year ago

this way I'm getting sum of all numbers inside one column. How can I calculate time with hours and minutes like in the example I posted.

Kacper Polak Over a year ago

Maybe change it to minutes then sum.

Collectives™ on Stack Overflow

calculate sum of two columns inside jquery datatables

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related