sum column value

naveen_iant

I want to sum earning column values to the total at end of code. I am using Jquery datatable to filter records by this code but unable to write code for the total.I've also tried footer callback of datatable but doesn't get desired result.

If anyone knows pls help me.






$(document).ready(function(){
$.datepicker.regional[""].dateFormat = 'dd/mm/yy';
$.datepicker.setDefaults($.datepicker.regional['']);
$('#example').dataTable({
"aoColumns": [{},
]
} )
.columnFilter({ sPlaceHolder: "head:before",
aoColumns: [ { type: "hidden" },
{ type: "hidden" },
{ type: "hidden" },
{ type: "hidden" },
{ type: "hidden" },
{ type: "hidden" },
{ type: "hidden" },
{ type: "hidden" },
{ type: "hidden" },
{ type: "date-range", sRangeFormat: "From Date{from} To Date {to}" },
{ type: "hidden" },
{ type: "hidden" },
{ type: "hidden" }
]

});
});







Agent Code
Agent Name
Designation
Account No.
Customer Name
Plan No.
Invoice
Bill Amt.
Bill Date
Pay Date
Insta. No.
Earning
Remark