Datagrid column sum

[Marco]

Hi !
j need some help
Is it possible to get the sum of a data grid column

j need to put the result in another field.

Thanks

[jarry]

Please use the 'formatter' function to set the calculate field.

Code:

$('#dg').datagrid({
	columns:[[
		{field:'sum',title:'Sum',width:100,
			formatter:function(value,row){
				return row.v1+row.v2+row.v3;
			}
		}
	]]
})

[Marco]

Thanks for your replay

but j  wa searching for

something like this img.

[yamilbracho]

It could be something like :

Code:

$('#dg').datagrid({
	onLoadSuccess:function(data) {
	  var sum = 0;
	  for (i = 0; i < data.length; i++) {
	     sum+=data[i].YourField;
	  }
	  $('#Imponible').text(sum);
	}
})

[Marco]

Hi !
Thanks for your interest

J try your code but it does not work maybe j do something wrong


here's my code


<a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-add" plain="true" onclick="somma()">Somma</a>

<div class="fitem" >
 <label>Imponibile:</label>
 <input id="Imponibile" name="Imponibile" class="easyui-textbox"  style="width:80px;height:20px" >



function somma ()
{
$('#tt_dt').datagrid('load')
$('#tt_dt').datagrid({
   onLoadSuccess:function(data) {
     var sum = 0;
     for (i = 0; i < data.length; i++) {
        sum+=data.Totale_riga;
     }
     $('#Imponible').text(sum);
   }
})

}
//-------------------------------------------------------------

[yamilbracho]

Change function summa() to :

Code:

function somma () {
  var data = $('#tt_dt').datagrid('getData');
  var sum = 0;
 
  for (i = 0; i < data.length; i++) {
        sum+=data.Totale_riga;
  }
	 
  // just to show if the sum is OK
 alert('sum=' + sum);
 $('#Imponible').textbox('setText', sum);
}

[Marco]

It seems that the sum is not ok..

[yamilbracho]

My mistake, try this :

Code:

function somma () {
  var data = $('#tt_dt').datagrid('getData');
  var rows = data.rows;
  var sum = 0;
 
  for (i=0; i < rows.length; i++) {
        sum+=rows[i].Totale_riga;
  }
	 
  // just to show if the sum is OK
 alert('sum=' + sum);
 $('#Imponible').textbox('setText', sum);
}

[Marco]

It does the text sum not .
it does not the true mathematical sum.

[yamilbracho]

Well, you only need to convert a string to number because it returns the concatenation of the column values...
Change the line in the loop where you want to add the column values to :

Code:

sum+=parseFloat(rows[i].Totale_riga);

[Marco]

Ok it works fine !!!

Thanks a lot