Perform the multiplication operation on two values retrieved from the API response and then calculate the total sum

Question

Perform the multiplication operation on two values retrieved from the API response and then calculate the total sum

I am currently pulling information from an API and I'm looking to perform a calculation on the data. Specifically, I want to multiply two different values from the response and then sum up the totals. While I already know how to sum all the values using reduce:

        function getHistoricSales(){
         $http.get('api/SomeApi')
         .then(function(data){
            $scope.salesResult = data.data.Response;

                var hResults = $scope.salesResult.reduce((a, b) => a + b.Cost, 0);
                $scope.historic = hResult.toFixed(2).replace(/\d(?=(\d{3})+\.)/g, '$&,');
               });
            }

However, if for example, the response includes not just the Cost (b.Cost), but also the Quantity. So, my question is how can I first multiply each Cost by its corresponding Quantity, and then sum the results?

I am working with JavaScript and AngularJS.

Any help would be greatly appreciated. Thank you in advance...

javascript angularjs

Answer 1

Answer №1

It seems like the solution you're seeking is:

let totalCost = $scope.salesResult
                       .map(sr => sr.Cost * sr.Quantity)
                       .reduce((a, b) => a + b);

This code snippet will calculate the total cost of each sales result by multiplying the cost and quantity, then summing them up.

Here's an example to illustrate this process:

const data = [
 {Cost: 10, Quantity: 15},
 {Cost: 5, Quantity: 11},
 {Cost: 2, Quantity: 110},
 {Cost: 5, Quantity: 90},
]

const result = data
              .map(sr => sr.Cost * sr.Quantity)
              .reduce((a, b) => a + b);

console.log(result);

Answer 2

It seems like the solution you're seeking is:

let totalCost = $scope.salesResult
                       .map(sr => sr.Cost * sr.Quantity)
                       .reduce((a, b) => a + b);

This code snippet will calculate the total cost of each sales result by multiplying the cost and quantity, then summing them up.

Here's an example to illustrate this process:

const data = [
 {Cost: 10, Quantity: 15},
 {Cost: 5, Quantity: 11},
 {Cost: 2, Quantity: 110},
 {Cost: 5, Quantity: 90},
]

const result = data
              .map(sr => sr.Cost * sr.Quantity)
              .reduce((a, b) => a + b);

console.log(result);

Answer 3

Answer №2

To ensure accurate calculations in the reduce() function for each item in $scope.salesResult, it's important to consider cases where a quantity property may be optional. By checking for and handling instances where the quantity is undefined, you can prevent errors caused by multiplying by an undefined value.

var salesResult = [
  // Some items only have the cost
  { cost: 10 },
  { cost: 10 },
  // Some items might also have a quantity
  { cost: 10, quantity: 10 },
  { cost: 10, quantity: 10 },
];

var hResults = salesResult.reduce((total, result) =>
  total + (result.quantity
    ? result.cost * result.quantity
    : result.cost), 0);
    
console.log(hResults); // 220

Answer 4

To ensure accurate calculations in the reduce() function for each item in $scope.salesResult, it's important to consider cases where a quantity property may be optional. By checking for and handling instances where the quantity is undefined, you can prevent errors caused by multiplying by an undefined value.

var salesResult = [
  // Some items only have the cost
  { cost: 10 },
  { cost: 10 },
  // Some items might also have a quantity
  { cost: 10, quantity: 10 },
  { cost: 10, quantity: 10 },
];

var hResults = salesResult.reduce((total, result) =>
  total + (result.quantity
    ? result.cost * result.quantity
    : result.cost), 0);
    
console.log(hResults); // 220

Perform the multiplication operation on two values retrieved from the API response and then calculate the total sum

Answer №1

Answer №2

Similar questions

angular2 : problem encountered with communication to rest api

Do I need to include $scope in my controller for this AngularJs?

Is it possible to pass a variable as an input parameter in the Date constructor when creating a timestamp in Firebase

Sending data through the backbone form?

Ways to simultaneously apply fade in and fade out effects using CSS

update embed - new command

The radio button is displaying the text 'on' instead of its designated value

Maintaining the integrity of a list within a for loop

Reveal the hidden div by sliding it up from the bottom

When a custom icon is clicked in the vue-select dropdown, the custom method is not activated

AJAX Post Request Function without Form That Does Not Reset

React - updating key prop does not trigger re-render of child component

Ways to stop Bootstrap collapse from displaying depending on a certain condition in bs5 framework

Issue: mongoose.model is not a valid function

Turn off integrity verification for local dependencies in package-lock.json

Is there a way in Vue to switch between encrypted and unencrypted content in an input field?

I need a regex pattern that will only match numeric values

The callback keeps getting triggered repeatedly, and I'm struggling to understand the reason behind it

BlockUI - Uncaught error: The object does not contain the method 'blockUI'

Ways to set a default image for an <img> tag