Adding Totals on Local Array
Since local array loads so fast that we need to add a timeout for the total formula to wait for DOM to finish loading.
Add the following first
$dg->set_grid_property(array("footerrow"=>true));Then use a separate javascript block in a timeout.
<script>setTimeout(function(){ var colSum = $('#data1').jqGrid('getCol', 'quantity', false, 'sum'); // other options are: avg, count $('#data1').jqGrid('footerData', 'set', { 'name': 'Total', 'quantity': colSum });}, 300);</script>You may need to change the column name and grid name accordingly.