Subtotal array

[mouac01]

I have this array:

[{"acct":"A1","d r":100,"cr":100 },{"acct":"A2", "dr":200,"cr":2 00},
{"acct":"A1","d r":300,"cr",300 },{"acct":"A2", "dr":400,"cr",4 00}]

How would I get the subtotal of each acct so that total for A1 dr/cr
is 400 and total for A2 dr/cr is 600.
TIA...

[scripts.contact]

On May 23, 6:35 pm, moua...@yahoo.c om wrote:

I have this array:

[{"acct":"A1","d r":100,"cr":100 },{"acct":"A2", "dr":200,"cr":2 00},
{"acct":"A1","d r":300,"cr",300 },{"acct":"A2", "dr":400,"cr",4 00}]

How would I get the subtotal of each acct so that total for A1 dr/cr
is 400 and total for A2 dr/cr is 600.

-----
function getTotal(arr,ac c){
var i=0,n,drtotal=0 ,crtotal=0;
while(n=arr[i++])
if(n.acct==acc) {
drtotal+=n.dr
crtotal+=n.cr
}
return [drtotal,crtotal]
}

-----

Example:
d=[{"acct":"A1","d r":100,"cr":100 },{"acct":"A2", "dr":200,"cr":2 00},
{"acct":"A1","d r":300,"cr":350 },{"acct":"A2", "dr":400,"cr":4 00}]
alert(getTotal( d,"A1"))

[mouac01]

On May 23, 6:00 pm, "scripts.contac t" <scripts.cont.. [e-mail]>
wrote:

On May 23, 6:35 pm, moua...@yahoo.c om wrote:I have this array:

[{"acct":"A1","d r":100,"cr":100 },{"acct":"A2", "dr":200,"cr":2 00},
{"acct":"A1","d r":300,"cr",300 },{"acct":"A2", "dr":400,"cr",4 00}]

How would I get the subtotal of each acct so that total for A1 dr/cr
is 400 and total for A2 dr/cr is 600.

-----
function getTotal(arr,ac c){
var i=0,n,drtotal=0 ,crtotal=0;
while(n=arr[i++])
if(n.acct==acc) {
drtotal+=n.dr
crtotal+=n.cr
}
return [drtotal,crtotal]
}

-----

Example:
d=[{"acct":"A1","d r":100,"cr":100 },{"acct":"A2", "dr":200,"cr":2 00},
{"acct":"A1","d r":300,"cr":350 },{"acct":"A2", "dr":400,"cr":4 00}]
alert(getTotal( d,"A1"))

Thanks for your help.
I've decided to use this:

Array.prototype .subtotal=funct ion(grp,field1, field2){
for(var i=0,sum=0;i<thi s.length;i++){
if(this[i][field1]==grp){
sum+=Number(thi s[i][field2].toString().rep lace(/\$|\,/g,'')) || 0;
}
}
return sum;
}