Any quick tip on how to sum numbers in an array? [image] I would like to add a column that sums the numbers in the array of numbers in the last column. The array is a simple list of numbers, appended by the row.

Nope. Doesn’t work… the sum option is not available. [image]

Related: I would like the count of instances of an item from an array. [array]

Interesting! :thinking: I didn’t know that a Rollup column can count the items of array in each row, thanks for the tip! However, your goal is the sum right?.. I think a customized JS code can do it easy: This is my code by using an EC: [image] let len=p8.length; let x=0, total =0; while (x< len) { total+= parseInt(p8[x]); x++ ; } return total The problem here is that Glide’s JavaScript plugin does not support an array as input value so you must use another version or create a new version of that JavaScript plugin. Maybe @david can read this note and carry out an improvement of his plugin to support these cases. My version to work with this case runs on Replit: https://SNB-YesCode.gustavovalero.repl.co Hope it helps you! Feliz noche @Simon_Hill

What are you using to get that rolling total array? Seems like it’s being read as text.

Right! It is the reason why I use parseInt() in the code. This covers all cases so far. Edited I already know what you mean Thind, of course, if the arrays have numeric values the Rollup operation would have worked perfectly!! Saludos!

This seems like an oversight. @mark @david?

What is this Rolling total array column? How is it configured? Glide does not recognize it as an array of numbers. [image]

[image] BlakeWS: [array] Hola @BlakeWS You can try with this JS code until Glide’s JavaScript plugin can support arrays as input values (parameter) [image] let len=p8.length; let total=0; for (let x= 0; x< len; x++) { if (p1==p8[x]) total ++ } return total My Source’s URL on Replit is : https://snb-yescode.gustavovalero.repl.co Saludos!

@gvalero or: return p8.filter(x => x === p1).length :wink:

How can I sum numbers in an array?

Ask for Help

Robert_Petitto November 12, 2021, 7:37pm 21

This is the same reason why you can’t numerically sort a plugin > unique array as described here:

Topic		Replies	Views
How to sum the array Elements in Glide? Ask for Help	7	688	October 28, 2023
Sum an Array Ask for Help	5	461	September 7, 2023
Sum of numbers in array Ask for Help	23	978	February 19, 2023
Rollup and average function on an array not available Ask for Help	6	436	August 22, 2023
Create a sum function from price to display the total Ask for Help	8	864	March 3, 2023

How can I sum numbers in an array?

Related topics