1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
var selInfo = grid.getSelection();
var calcColumn = ["Quantity", "UnitPrice"];

console.log("Selection: ", JSON.stringify(selInfo));

if (!selInfo) {
    return;
};

var datas = grid.getSelectionData();
var totCnt = 0;
var cnt = 0;
var sum = 0;
for (var i = 0 ; i < datas.length; i++) {
    var keys = Object.keys(datas[i]);
    for (var j = 0; j < keys.length; j++) {
        totCnt++;
        if (calcColumn.indexOf(keys[j]) > -1) {
            sum += datas[i][keys[j]];
            cnt++;
        }
    }
};

var avg = sum / cnt;
console.log("Total Cell Count: " + totCnt.toLocaleString());
console.log("Avg: " + (isNaN(avg) ? 0 : avg).toLocaleString());
console.log("Count: " + cnt.toLocaleString());
console.log("Sum: " + sum.toLocaleString());
alert("Sum: " + sum.toLocaleString());