Answers

• colin Posts: 15,177Questions: 1Answers: 2,590

  November 2021

  This example shows how to sum the column, it would be the same principle with a division in there too,

  Colin
• jackalbright Posts: 14Questions: 4Answers: 0

  January 2023

  Colin, in the example that you point to, how do you know how many rows there are? In the original post, there are two rows. Is there a built-in function that gives us the number or rows or do you have to count them as you iterate over them?
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  January 2023 edited January 2023

  @jackalbright There are a couple options.

  1. The footerCallback docs state the the data parameter is the full array of table data. You can use data.length to get the full number of rows.
  2. Using the count() API you can get the number of rows in the data set if using selector-modifier to calculate over the page or filtered data. Something like this:

  var rowCount = api
                  .column(4, { page: 'current' })
                  .data()
                  .count();
  

  Kevin
• Samk Posts: 6Questions: 2Answers: 0

  April 27

  I have a similar question but my cells are html input elements. Can the footer callback option work with. Columns made up of input text ?
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  April 27

  @Samk Yes. Taking the footerCallback example to start with and changing the Age column to text inputs.
  https://live.datatables.net/tiqezose/1/edit

  I added this function to get the value of the input:

      let inputVal = function (i) {
        return intVal( $(i).val() );
      }
  

  I changed the reduce function to call the inputVal function to get the input:

  .reduce((a, b) => intVal(a) + inputVal(b), 0);
  

  You solution may need to be different depending on what you are doing and how you have Datatables configured. If you still need help then please provide a test case (update mine if you wish) to show exactly what you have so we can offer more specific suggestions.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin
• Samk Posts: 6Questions: 2Answers: 0

  April 28

  thanks for the pointer kevin. ive posted the datatable here https://live.datatables.net/zalitado/1/edit?html, js, output

  where im trying to calc the min, avg and total of the columns. got the total but it doesn't fire dynamically .
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  April 28

  @Samk see my answer in your other thread.

  Kevin