How to sum value of two json object key?

Question

"bills": [
    {
        "refNo": 17,
        "billDate": "1-apr-2016",
        "dueDate": "30-apr-2016",
        "pendingAmount": 4500,
        "overdueDays": 28
    },
    {
        "refNo": 20,
        "billDate": "15-apr-2016",
        "dueDate": "3-may-2016",
        "pendingAmount": 56550,
        "overdueDays": 15
    }
]

I want to sum "pendingAmount" field. It should be return like pendingAmount: 61050

boehm_s · Accepted Answer · 2022-02-25T12:59:38.590

You can use Array#map and then Array#reduce to flatten your object and then sum the result of the map :

bills.map(bill => bill.pendingAmount).reduce((acc, amount) => acc + amount);

here's a snippet :

var bills = [
          {
            "refNo": 17,
            "billDate": "1-apr-2016",
            "dueDate": "30-apr-2016",
            "pendingAmount": 4500,
            "overdueDays": 28
          },
          {
            "refNo": 20,
            "billDate": "15-apr-2016",
            "dueDate": "3-may-2016",
            "pendingAmount": 56550,
            "overdueDays": 15
          }
        ];
var res = bills.map(bill => bill.pendingAmount).reduce((acc, amount) => acc + amount);
console.log(res)

Hope it helps,

Best regards,

score 6 · Answer 2 · answered Jun 08 '17 at 12:53

The reduce() method applies a function against an accumulator and each element in the array (from left to right) to reduce it to a single value.

var bills = [
          {
            "refNo": 17,
            "billDate": "1-apr-2016",
            "dueDate": "30-apr-2016",
            "pendingAmount": 4500,
            "overdueDays": 28
          },
          {
            "refNo": 20,
            "billDate": "15-apr-2016",
            "dueDate": "3-may-2016",
            "pendingAmount": 56550,
            "overdueDays": 15
          }
        ];
        
        
      var result = bills.reduce(function(_this, val) {
          return _this + val.pendingAmount
      }, 0);

    console.log(result)
    //61050 answer

Fabian · Answer 3 · 2017-06-09T05:45:59.867

0

You could use the following snippet:

var sum = JSON.parse(bills).reduce(function(acc, val){
  return acc.pendingAmount + val.pendingAmount;
}, {pendingAmount: 0});

it uses the array.prototype.reduce() function on the parsed JSON. The second argument of the reduce is the initial value passed to the reduce function

edited Jun 09 '17 at 05:45

answered Jun 08 '17 at 12:42

Fabian

531
4
11

1

Might be this code resolve the problem.add proper description in your answer. – NarendraR Jun 08 '17 at 13:32

score 0 · Answer 4 · answered Jun 08 '17 at 12:50

0

A one-liner with some ES2015 destructuring:

json.bills.reduce(({pendingAmount: a}, {pendingAmount: b})=> a+b)

answered Jun 08 '17 at 12:50

gunn

8,999
2
24
24

score -1 · Answer 5 · answered Jun 08 '17 at 12:42

-1

Use this:

let sum, billsPOJO;

billsPOJO = YOURJSON.bills;

sum = 0;

for (let i = 0; billsPOJO.length; i++) {
 sum += billsPOJO[i].pendingAmount; 
}

answered Jun 08 '17 at 12:42

F.bernal

2,594
2
22
27

Its a whole lot of work to do. Why do this if JS mainly ES6 is giving you shorthand & oneliner way to achieve this! – TalESid Jun 20 '20 at 11:21

How to sum value of two json object key?

5 Answers5

Linked