Sum of values in column of a table

Question

question

sachin tandulkar asked Nov 9, '16 anthony.johnson edited Nov 10, '16

Sum of values in column of a table

Is there a readymade function to get the sum of all the values in a particular column of a table? I can do it with for loop but again, lot of coding. Please let me know.

Software Version:

Choose One

tables

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2016-11-09T23:47:49Z

Matthew Gillespie answered Nov 9, '16 sachin tandulkar commented Nov 10, '16

You can use the query command and use SQL to find the sum:

query("SELECT SUM([Col 1]) FROM GlobalTable1");
int sum = getqueryvalue(1, 1);

But that's about the same amount of coding as a for loop:

int sum = 0;
for(int i = 1; i <= gettablerows("GlobalTable1"); i++)
     sum += gettablenum("GlobalTable1", i, 1);

· 3

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

sachin tandulkar commented · Nov 10, 2016 at 04:03 PM

@Arun KR Thanks Arun, I already wrote a user command. Just wanted to know whether they have any automatic function.

1 ·

sachin tandulkar commented · Nov 10, 2016 at 02:24 PM

Thankks Matthew. I thought so. I was hoping for something like

totalsum=columnsum("Tablename",range from column).

0 ·

Arun Kr sachin tandulkar commented · Nov 10, 2016 at 02:42 PM

Hei Sachin,

You can create a user command for doing this.

Arun KR

1 ·

Answer 2 · 2016-11-10T19:11:57Z

anthony.johnson answered Nov 10, '16 anthony.johnson edited Nov 10, '16

getdatastat(STAT_SUM, gettablerows("GlobalTable1"), gettablenum("GlobalTable1", count, 1))

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question