Why does summing up a variable from an array give me NaN? (Javascript)

Question

I have this array containing appointments:

let appointments = [
{"appointmentId": 001239, "subject": "Something", "Client": "Bob", "StartTime": "2020-04-16T11:00:00.000Z", "EndTime": "2020-04-16T11:30:00.000Z", "km": 90},
{"appointmentId": 001240, "subject": "Something", "Client": "Alvera", "StartTime": "2020-04-16T11:00:00.000Z", "EndTime": "2020-04-16T11:30:00.000Z", "km": 50},
{"appointmentId": 001241, "subject": "Something", "Client": "Bob", "StartTime": "2020-04-17T11:00:00.000Z", "EndTime": "2020-04-17T11:30:00.000Z", "km": 30}]

Now what I want is to sum the km by client, so for example Bob: total: 120. Alvera total: 50. And also with the differences in minutes of StartTime and EndTime. With the use of dayjs library I calculate the difference between the times. This is a method which does the accumulation of km and Times. The km works perfectly, however, the difference gives NaN. What am I doing wrong?

  var result = [];

   this.appointments.reduce(function (res, value) {
if (!res[value.Client]) {
  res[value.Client] = {
    km: 0,
    Client: value.Client,
    StartTime: dayjs(value.StartTime),

    EndTime: dayjs(value.EndTime),
    difference: dayjs(value.EndTime).diff(dayjs(value.StartTime), 'minute')  % 60

  };
  result.push(res[value.Client])
}
res[value.Client].km += value.km;

res[value.Client].difference += value.difference; //here I try to sum the differences by Client, when I remove this line, I just see the difference of the first appointment.
return res;


 }, {});

`value.difference` is undefined. There are no `difference` properties in the input data. — Đinh Carabus, Apr 18 '20 at 20:18
@subarachnid ah, i see. But why is the line above regarding 'km' working despite being the same? — Y_Lakdime, Apr 18 '20 at 20:20
Because your input data defines these properties (`..."km": 90}`), — Đinh Carabus, Apr 18 '20 at 20:20
ah, i totally overlooked that. Thank you. Changed it to 'res[value.Client].difference += res[value.Client].difference' and it works — Y_Lakdime, Apr 18 '20 at 20:22
@subarachnid Oh i see that the valie `difference` is doubled. That is not supposed to be — Y_Lakdime, Apr 18 '20 at 20:26

Đinh Carabus · Accepted Answer · 2020-04-21T16:58:05.447

Maybe this helps?

let appointments = [
  {
    appointmentId: 001239,
    subject: "Something",
    Client: "Bob",
    StartTime: "2020-04-16T11:00:00.000Z",
    EndTime: "2020-04-16T11:30:00.000Z",
    km: 90
  },
  {
    appointmentId: 001240,
    subject: "Something",
    Client: "Alvera",
    StartTime: "2020-04-16T11:00:00.000Z",
    EndTime: "2020-04-16T11:30:00.000Z",
    km: 50
  },
  {
    appointmentId: 001241,
    subject: "Something",
    Client: "Bob",
    StartTime: "2020-04-17T11:00:00.000Z",
    EndTime: "2020-04-17T11:30:00.000Z",
    km: 30
  }
];

let totals = appointments.reduce(function (res, value) {
  let diff = dayjs(value.EndTime).diff(dayjs(value.StartTime), "minute") % 60;
  if (!res[value.Client]) {
    // set initial value
    res[value.Client] = {
      km: value.km,
      Client: value.Client,
      difference: diff
    };
  } else {
    // sum up
    res[value.Client].km += value.km;
    res[value.Client].difference += diff;
  }
  return res;
}, {});

totals = Object.values(totals);

console.log(totals);

<script src="https://cdnjs.cloudflare.com/ajax/libs/dayjs/1.8.24/dayjs.min.js"></script>

Hi, why is this function returning an Object? I prefer to have an array like this: Index 0: `Client: "Bob" difference: 60 km: 93` — Y_Lakdime, Apr 20 '20 at 20:14
Hi @user3660293, you can convert the object to an array by simply doing `totals = Object.values(totals);`. I edited my post so you can try for yourself. — Đinh Carabus, Apr 21 '20 at 16:58

Why does summing up a variable from an array give me NaN? (Javascript)

1 Answers1