how to sum and average various columns at same time

winntix

hi everyone

i have some links to show my problem, that is to sum and average the table footer at the same time, but i have this results
http://estrellasdelascaobas.com/Team_Stats.php?torneo=actl&team=Verdes%208-10
http://estrellasdelascaobas.com/Team_Stats2.php?torneo=actl&team=Verdes%208-10
http://estrellasdelascaobas.com/Team_Stats3.php?torneo=actl&team=Verdes%208-10
http://estrellasdelascaobas.com/Team_Stats4.php?torneo=actl&team=Verdes%208-10
http://estrellasdelascaobas.com/Team_Stats5.php?torneo=actl&team=Verdes%208-10
http://estrellasdelascaobas.com/Team_Stats6.php?torneo=actl&team=Verdes%208-10

the only way to have the result that i expect was doing this
http://estrellasdelascaobas.com/Team_Stats7.php?torneo=actl&team=Verdes%208-10, this is equal to make the sum or average manually , can someone help to solve this

thanks

PD: sorry english is not my natural language

winntix

sorry , chechk the footer on the second table

thanks

winntix

make a view page source and look the code

winntix

after make a search on the web (googled) i found this solutions

"fnFooterCallback": function (nRow, aasData, iStart, iEnd, aiDisplay) {

        var columnas = [1,2,3,4,5,6,8,10,11,12,13,14,15,16,17,18]; //the columns you wish to add            
        for (var j in columnas) {
            var columnaActual = columnas[j];
            var total = 0;
            for (var i = iStart; i < iEnd; i++) {
                total = total + parseFloat(aasData[aiDisplay[i]][columnaActual]);
            }
            $($(nRow).children().get(columnaActual)).html(total);

        } // end of columns sum

        var columnas = [7,9]; //the columns you wish to average            
        for (var j in columnas) {
            var columnaActual = columnas[j];
            var total = 0;
            for (var i = iStart; i < iEnd; i++) {
                ncolumns=iEnd;
                total = total + parseFloat(aasData[aiDisplay[i]][columnaActual])/ncolumns;
            }
            $($(nRow).children().get(columnaActual)).html((total).toFixed(3));

        } // end of averages colummns

    } // end footercallback