jQuery Grid Plugin - jqGridForum

Topic RSS

jQgrid - summaryType: mysum

11/11/2011
19:15

milad

Member

Members

Forum Posts: 33

Member Since:
03/10/2011

Offline

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.

11/11/2011
21:13

milad

Member

Members

Forum Posts: 33

Member Since:
03/10/2011

Offline

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?

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
43 Guest(s)

Currently Browsing this Page:
1 Guest(s)