Forum



07:03

06/02/2012

I want to have sum of a column in footerData. I am loading data from "mydata" Here is the code I am using
var colNames=["id","Name","Owner","Amount"];
var colModel=[
{name: 'id',index: 'id',hidden: true},
{name: 'Name',index: 'Name'},
{name: 'Owner',index: 'Owner'},
{name: 'Amount',index: 'Amount',align: 'right',sorttype: 'float',formatter: 'currency',summaryType: 'sum',
formatoptions: {decimalSeparator: ",",thousandsSeparator: ",",decimalPlaces: 2,prefix: "$ "}}
];
var mydata=[
{id="374", Name="QA", Owner="James Robert", Amount="100.00"},
{id="374", Name="QA", Owner="Mayank Khandelwal", Amount="200.00"}
]
jQuery("#list2″).jqGrid({
data: mydata,
datatype: "local",
height:'auto',
rowNum: 10,
rowList: [10,20,30],
colNames:colNames,
colModel:colModel,
pager: "#pager2″,
viewrecords: true,
sortname: 'name',
grouping:false,
groupingView : {
groupField : ['Owner'],
groupSummary : [true],
groupColumnShow : [true]
},
footerrow: true
});
I want to show a footer of Amount some thing like this "<b>Total: </b> $200.00″
Most Users Ever Online: 715
Currently Online:
82 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66