Sum array values

General
1

I have an array that looks like:

0: object
time: "2020-06-18T23:00:00.000Z"
consumption_value_inc_vat: 0.498036
1: object
time: "2020-06-18T23:30:00.000Z"
consumption_value_inc_vat: 0.4657905
....................

How can I sum the "consumption_value_inc_vat"?
Preferably in JSONata.

2

assuming that that is msg.payload, try $sum(payload.consumption_value_inc_vat)

1 Like
3

Thanks Paul, I had a brainfart trying to do this, overthinking!!!!

1 Like
4

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.