Colum Sum after Filter (footer)

Discontinued products Uncategorized discussions
#1

Hi,



i have problems with Colum Sum in footer after setting a Filter- the Sum of the colum ist the sum over all, every time, but i want to have only the sum for the displayed rows. Is that possible?



I use the function of the examples:



function calculateFooterValues(stage){

         if(stage && stage!=2)

         return true;

         var nrQ = document.getElementById(“nr_q”);

         nrQ.innerHTML = sumColumn(12) // 12 = c12 my colum

          return true;     }

        

        

         function sumColumn(ind){

         var out = 0;

         for(var i=0;i<mygrid.getRowsNum();i++){ out+= parseFloat(mygrid.cells2(i,ind).getValue())

         }         return out;    }



Thank you

Uwe

#2

You can add next line of code which most probably will solve issue

mygrid.attachEvent(“onFilterEnd”,function(){   //called each time after filtering
    calculateFooterValues(2);
});

Also, latest version supports automatic sum counters
    dhtmlx.com/docs/products/dhtmlxG … r_num.html