combining different sets of data within a JSON object

Question

combining different sets of data within a JSON object

Is there a way to calculate the total sum of values in a JSON dataset?

I'm attempting to add up all the values in my dataset under the field TaxAmount:

const url = "https://...........";
const xhr = new XMLHttpRequest();
xhr.onreadystatechange = function () {
    if (xhr.readyState == 4) {
        const data = JSON.parse(xhr.response);
        console.log(data);           

    }
};
xhr.open("GET", url, true);
xhr.send();

Here is a peek at the data:

https://i.sstatic.net/ZqXie.png

If we examine one of the objects in the array returned above:

{
   [functions]: ,
   __proto__: { },
   AccountID: null,
   AccountUID: null,
   AgentCost: 0,
   Amount: 24.3,
   AccountsItemID: null,
   TaxAmount: 2.01
}

I've made an effort to total the TaxAmount for all elements as follows:

let totalTaxAmount = data.reduce(function(previousValue, currentValue) {             
         return previousValue += currentValue["TaxAmount"];
    }, 0);

Do you think using a data.forEach.reduce would be more appropriate?

Is there a way to calculate the total sum of values in a JSON dataset?

javascript json xmlhttprequest

Answer 1

Answer №1

Here is a helpful snippet to calculate the total tax amount:

var transactions = [
{
   AccountID: null,
   AccountUID: null,
   AgentCost: 0,
   Amount: 24.3,
   AccountsItemID: null,
   TaxAmount: 2.01
},
{
   AccountID: null,
   AccountUID: null,
   AgentCost: 0,
   Amount: 24.3,
   AccountsItemID: null,
   TaxAmount: 3.01
}
];

 var totalTaxAmount = transactions.reduce(function(previousValue, currentValue) {             
         previousValue += currentValue["TaxAmount"];
         return previousValue;
    }, 0);
console.log(totalTaxAmount);

Answer 2

Here is a helpful snippet to calculate the total tax amount:

var transactions = [
{
   AccountID: null,
   AccountUID: null,
   AgentCost: 0,
   Amount: 24.3,
   AccountsItemID: null,
   TaxAmount: 2.01
},
{
   AccountID: null,
   AccountUID: null,
   AgentCost: 0,
   Amount: 24.3,
   AccountsItemID: null,
   TaxAmount: 3.01
}
];

 var totalTaxAmount = transactions.reduce(function(previousValue, currentValue) {             
         previousValue += currentValue["TaxAmount"];
         return previousValue;
    }, 0);
console.log(totalTaxAmount);

Answer 3

Answer №2

It is recommended that you calculate the sum of pv and cv, with the second argument for reduce set to 0 instead of an object:

var totalTaxAmount = data.reduce(
  function(pv, cv) {
    /** Added a return statement and kept pv unchanged */return pv + cv["TaxAmount"];
  }, 
  /** Updated to zero */0
);

Answer 4

It is recommended that you calculate the sum of pv and cv, with the second argument for reduce set to 0 instead of an object:

var totalTaxAmount = data.reduce(
  function(pv, cv) {
    /** Added a return statement and kept pv unchanged */return pv + cv["TaxAmount"];
  }, 
  /** Updated to zero */0
);

combining different sets of data within a JSON object

Answer №1

Answer №2

Similar questions

AngularJS controller failing to update the angular variable

Unable to fetch local file using ajax from a local HTML page

Encountering an Unresolved Runtime Issue: TypeError arises when attempting to access properties of undefined (specifically 'call') while utilizing the Image component in next.js

The input field will remain inactive until the radio button is selected (HTML)

Using Gmail in conjunction with Heroku for email delivery

Creating a multi-dimensional array using information from a database

Unable to insert an array within a function

Utilize the jQuery function as a callback argument

Designing a personalized user template for a feature in Angular 2

Extract only the contact information stored within a complex JSON structure

Ember-Data: Extracting nested JSON properties with ease

Exploring the elements within array structures

What is the process for submitting and storing a collection of files in a database as a list?

Transform JSONB arrays from Postgres into a JavaScript array containing individual JSON elements

The JSON data failed to translate the integer field

Cycle2 does not display the cycle pager

Material-UI Autocomplete can only save and display one specific property of an object at a time

In JavaScript, there is a missing piece of logic when iterating through an array to find

Transforming a JavaScript object into a different shape

What is Flask's approach to managing JSON data?