milad on jQgrid - summaryType: mysum

Fri, 11 Nov 2011 21:13:09 +0200

I managed to acheive this by doing the following:

I define global variables for the current value of column A and Column C, and the current group by

var tColA = 0.0;

var tColC = 0.0;

var tCurrentGroupBy;

Then in my function, I do the following:

function mysum(a, b, c) {
        if (tCurrentGroupBy!= c.GroupByCol) {
            tColA= 0.0;
            tColC= 0.0;
            tCurrentGroupBy= c.GroupByCol;
            tColA= tColA + parseFloat(c.ColA);
            tColC= tColC + parseFloat(c.ColC);
        }
        else {
           tColA= tColA + parseFloat(c.ColA);
             tColC= tColC + parseFloat(c.ColC);
        }

return ((tColC / tColA) * 100);
}

not sure if there is a better way to do this, but this seems to work. Are there any other suggestions?

milad on jQgrid - summaryType: mysum

Fri, 11 Nov 2011 19:15:15 +0200

Do you have a good example where a function is used for the summaryType property? Let's say I have a grid that contains grouping and has 3 columns (A, B, C). What I would like to do is make the summaryType property for column C point to a function. In that function, I need to able to set the summary total for column C within each group as: sum(C) / sum(A) * 100. Note, columns A and B, have their own totals (but those are just summaryType: 'sum'). What is the best way to do what I am describing for the total summary row for column C?

Thank you.

jQuery Grid Plugin - jqGrid - Topic: jQgrid - summaryType: mysum

milad on jQgrid - summaryType: mysum

milad on jQgrid - summaryType: mysum