Start Building Professional
Web Apps Today

custom formulae

I would like to know in treegird , is it possible to have custom formuale to display custom value on summary rows.THis custom valued will generated by applying custom formulae on child cells.

Built in math allow only "sum" as aggregation function.

In case of "auto-calculated-values-in-footer", it possible to extend existing functionality and add custom formula, it not so simple but possible

For example to add sum(x^2) next code need to be added in project

dhtmlXGridObject.prototype._in_header_stat_sum2=function(t,i,c){
    var calck=function(){
        var summ=0;
        this.forEachRow(function(id){
             // id - id of row
             // i - index of column
             summ += Math.pow(this.cells2(id,i).getValue(),2);   // main formula
        });
        return summ;
    }
    this._stat_in_header(t,calck,i,c);   //default call, to attach all necessary handlers
}


now you can use your formula by specifing in header|footer

grid.attachFooter("A,B,#stat_sum2,C");