How to sum json array

Question

How can I to sum elements of a JSON array like this, using jQuery:

"taxes": [ 
    { "amount": 25, "currencyCode": "USD", "decimalPlaces": 0, "taxCode": "YRI" },
    { "amount": 25, "currencyCode": "USD", "decimalPlaces": 0, "taxCode": "YRI" },
    { "amount": 10, "currencyCode": "USD", "decimalPlaces": 0, "taxCode": "YRI" }
]

The result should be:

totalTaxes = 60

@Louis: You forgot the minus sign in front of one of those 25's. — sberry
– sberry, Commented Apr 19, 2012 at 4:02

Eric · Accepted Answer · 2012-04-19 10:18:45Z

27

Working with JSON 101

var foo = {
        taxes: [
            { amount: 25, currencyCode: "USD", decimalPlaces: 0, taxCode: "YRI"},
            { amount: 25, currencyCode: "USD", decimalPlaces: 0, taxCode: "YRI"},
            { amount: 10, currencyCode: "USD", decimalPlaces: 0, taxCode: "YRI"}
        ]
    },
    total = 0,  //set a variable that holds our total
    taxes = foo.taxes,  //reference the element in the "JSON" aka object literal we want
    i;
for (i = 0; i < taxes.length; i++) {  //loop through the array
    total += taxes[i].amount;  //Do the math!
}
console.log(total);  //display the result

edited Apr 19, 2012 at 10:18

Eric

6,3936 gold badges50 silver badges72 bronze badges

answered Apr 19, 2012 at 4:03

epascarello

208k20 gold badges206 silver badges246 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jfriend00 Over a year ago

Except this isn't JSON. JSON is a text format. This is just javascript object and array notation.

Louis Over a year ago

Thank you. I took a part of a long JSON response. I'm sorry the mistakes in my question. But the sum is working with this. ;)

Ateş Göral · Accepted Answer · 2012-04-19 05:26:45Z

15

If you really must use jQuery, you can do this:

var totalTaxes = 0;

$.each(taxes, function () {
    totalTaxes += this.amount;
});

Or you can use the ES5 reduce function, in browsers that support it:

totalTaxes = taxes.reduce(function (sum, tax) {
    return sum + tax.amount;
}, 0);

Or simply use a for loop like in @epascarello's answer...

edited Apr 19, 2012 at 5:26

answered Apr 19, 2012 at 4:05

Ateş Göral

141k27 gold badges142 silver badges191 bronze badges

Collectives™ on Stack Overflow

How to sum json array

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related