Techniques for finding the total value of a JSON array

Question

Techniques for finding the total value of a JSON array

After retrieving values from a database, I am using them in JSON/javascript as an array. For example, see

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

The issue arises when trying to calculate the sum of the array elements.
I attempted to solve it with this code:

var obj1 = JSON.parse(data);
var mar = obj1.march;
var quantite = obj1.quant;
const sum = quantite.reduce((result,number)=> result+number);

console.log(sum);

Here is the output I received in the console

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

I am still learning about JSON and javascript, so any guidance or assistance would be greatly appreciated!

javascript json

Answer 1

Answer №1

All the items in the given array are strings, hence the usage of the + operator results in their concatenation. To perform addition and avoid this issue, you should first parse them into integers like so:

const sum = quantities.reduce((result, number) => parseInt(result) + parseInt(number));

Answer 2

All the items in the given array are strings, hence the usage of the + operator results in their concatenation. To perform addition and avoid this issue, you should first parse them into integers like so:

const sum = quantities.reduce((result, number) => parseInt(result) + parseInt(number));

Answer 3

Answer №2

It appears that your dataset consists of strings rather than integers. Consider refining your reduce function:

quantite.reduce((result,number) => parseInt(result)+parseInt(number));

Answer 4

It appears that your dataset consists of strings rather than integers. Consider refining your reduce function:

quantite.reduce((result,number) => parseInt(result)+parseInt(number));

Answer 5

Answer №3

Start with the initial value in the reduce() function and ensure that number is treated as a number when performing addition

quantity.reduce((result, num) => (result + Number(number)), 0);
                                        // start value   ^^

Answer 6

Start with the initial value in the reduce() function and ensure that number is treated as a number when performing addition

quantity.reduce((result, num) => (result + Number(number)), 0);
                                        // start value   ^^

Techniques for finding the total value of a JSON array

Answer №1

Answer №2

Answer №3

Similar questions

Issues with Jquery Div sliding transitions from right to left are not functioning correctly

Unable to establish a connection with the default port on Mongo DB while utilizing Node.js

Preserve the output from the jQuery ajax request

Can anyone provide guidance on uploading data to a mongodb database? I've attempted a few methods but keep encountering errors

The error message "firebase.initializeApp is not defined" indicates that the object is not properly initialized

How to stop a checkbox from being selected in Angular 2

Colorful D3.js heatmap display

Error: undefined property causing inability to convert to lowercase

The surprising behavior of Rails rendering partials even when they are commented out has

My JavaScript array is not working with the stringify function

Creating a Vue component using v-for and a factory function allows for dynamic

Is there a method in Discord.JS to remove an embed from a message sent by a user?

Modifying HTML text with JavaScript according to the content of the currently selected div

Unreliable static URLs with Next.js static site generation

JSON arrays that are nested within one another

Extract data from SOAP XML response sent by SOAP Client using PHP

Ways to transform the DropBox chooser button into an image

Error arises during JSON parsing if the data content contains the `%` symbol

Encountered an error with Winston and Elasticsearch integration: "TypeError: Elasticsearch is not a constructor

Tips for choosing a loaded element using the jQuery load() method