Jquery datatables totalling columns where the value is rendered as a hyerpilnk
<p>I'm using the DataTables 1.10.11 with the .sum() plugin option.</p>

<p>I can get the sum to work and total if the column is a number.  My problem is that a lot of the columns have been rendered as hyperlinks to allow a drill-down.  When I sum on these, the result is Nan.</p>

<p>Anyone have any ideas how to work-around this.</p>

<p>The below code works on column 13, as this is not rendered.  Columns 3-12 fail.</p>

<pre><code>        $('#tblDebtors').dataTable({
              "autoWidth":false
            , "drawCallback": function() {
                    var api = this.api();

                    // Total over all pages
                    var total = api.column(13).data().sum();

                    $(api.column(13).footer()).html(fncFmtNbr(total,2,"Y","Y"));
                }
            , "footer": true
            , "info":false
            , "JQueryUI":true
            , "ordering":true
            , "paging":false
            , "scrollY":"470px"
            , "scrollX":"1485px"
            , "scrollCollapse":true
            , "columnDefs": [
                        { className: "Left", "targets": [ 0,1 ] }
                    ,   { className: "Center", "targets": [ 2 ] }
                    ,   { className: "Right", "targets": [ 3,4,5,6,7,8,9,10,11,12,13 ] }
                    ,   {"targets": 3,
                            "data": null,
                            "render": function ( data, type, row ) {
                                return '&lt;a id="href_Current_'+row[0]+'" href="#"&gt;'+row[3]+'&lt;/a&gt;';
                            }
                        }
                    ,   {"targets": 4,
                            "data": null,
                            "render": function ( data, type, row ) {
                                return '&lt;a id="href_Pd1_'+row[0]+'" href="#"&gt;'+row[4]+'&lt;/a&gt;';
                            }
                        }
                    ,   {"targets": 5,
                            "data": null,
                            "render": function ( data, type, row ) {
                                return '&lt;a id="href_Pd2_'+row[0]+'" href="#"&gt;'+row[5]+'&lt;/a&gt;';
                            }
                        }
                    ,   {"targets": 6,
                            "data": null,
                            "render": function ( data, type, row ) {
                                return '&lt;a id="href_Pd3_'+row[0]+'" href="#"&gt;'+row[6]+'&lt;/a&gt;';
                            }
                        }
                    ,   {"targets": 7,
                            "data": null,
                            "render": function ( data, type, row ) {
                                return '&lt;a id="href_Pd4_'+row[0]+'" href="#"&gt;'+row[7]+'&lt;/a&gt;';
                            }
                        }
                    ,   {"targets": 8,
                            "data": null,
                            "render": function ( data, type, row ) {
                                return '&lt;a id="href_Pd5_'+row[0]+'" href="#"&gt;'+row[8]+'&lt;/a&gt;';
                            }
                        }
                    ,   {"targets": 9,
                            "data": null,
                            "render": function ( data, type, row ) {
                                return '&lt;a id="href_Pd6_'+row[0]+'" href="#"&gt;'+row[9]+'&lt;/a&gt;';
                            }
                        }
                    ,   {"targets": 10,
                            "data": null,
                            "render": function ( data, type, row ) {
                                return '&lt;a id="href_Pd7_'+row[0]+'" href="#"&gt;'+row[10]+'&lt;/a&gt;';
                            }
                        }
                    ,   {"targets": 11,
                            "data": null,
                            "render": function ( data, type, row ) {
                                return '&lt;a id="href_Older_'+row[0]+'" href="#"&gt;'+row[11]+'&lt;/a&gt;';
                            }
                        }
                    ,   {"targets": 12,
                            "data": null,
                            "render": function ( data, type, row ) {
                                return '&lt;a id="href_Total_'+row[0]+'" href="#"&gt;'+row[12]+'&lt;/a&gt;';
                            }
                        }
                ]
        });
</code></pre>