<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: Sum of a column in footerData</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/sum-of-a-column-in-footerdata</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/help/sum-of-a-column-in-footerdata/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>mayankk on Sum of a column in footerData</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/sum-of-a-column-in-footerdata#p25876</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/sum-of-a-column-in-footerdata#p25876</guid>
        	        	<description><![CDATA[<p>I want to have sum of a column in footerData. I am loading data from "mydata" Here is the code I am using</p>
<p>var colNames=["id","Name","Owner","Amount"];<br />var colModel=[<br />&#160;&#160; &#160;&#160;&#160; &#160;{name: &#39;id&#39;,index: &#39;id&#39;,hidden: true},<br />&#160;&#160; &#160;&#160;&#160; &#160;{name: &#39;Name&#39;,index: &#39;Name&#39;},<br />&#160;&#160; &#160;&#160;&#160; &#160;{name: &#39;Owner&#39;,index: &#39;Owner&#39;},<br />&#160;&#160; &#160;&#160;&#160; &#160;{name: &#39;Amount&#39;,index: &#39;Amount&#39;,align: &#39;right&#39;,sorttype: &#39;float&#39;,formatter: &#39;currency&#39;,summaryType: &#39;sum&#39;,<br />&#160;&#160; &#160;&#160;&#160; &#160;formatoptions: {decimalSeparator: ",",thousandsSeparator: ",",decimalPlaces: 2,prefix: "$ "}}<br />&#160;&#160; &#160;];<br />var mydata=[<br />&#160;&#160; &#160;&#160;&#160; &#160;{id="374", Name="QA", Owner="James Robert", Amount="100.00"},<br />&#160;&#160; &#160;&#160;&#160; &#160;{id="374", Name="QA", Owner="Mayank Khandelwal", Amount="200.00"}<br />&#160;&#160; &#160;&#160; ]</p>
<p>&#160;&#160; &#160;&#160; jQuery("#list2&#8243;).jqGrid({<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;data: mydata,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;datatype: "local",<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;height:&#39;auto&#39;,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;rowNum: 10,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;rowList: [10,20,30],<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;colNames:colNames,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;colModel:colModel,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;pager: "#pager2&#8243;,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;viewrecords: true,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;sortname: &#39;name&#39;,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;grouping:false,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupingView : { <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupField : [&#39;Owner&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupSummary : [true],<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;groupColumnShow : [true]<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;},<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; footerrow: true<br />&#160;&#160; &#160;&#160;&#160; &#160;});</p>
</p>
<p>I want to show a footer of Amount some thing like this "&#60;b&#62;Total: &#60;/b&#62; $200.00&#8243;</p>
]]></description>
        	        	<pubDate>Mon, 06 Feb 2012 07:03:26 +0200</pubDate>
        </item>
</channel>
</rss>