topic No output result for summation of multiple columns in Discussions

No output result for summation of multiple columns

TAKAMX — Thu, 17 Oct 2024 14:50:23 GMT

Trying to create a new column to represent a grouping of several columns together by using the sum function in the formula box. I've tried a few different ways (manually clicking each column to be used and using the + sign, selecting the statistical sum function and adding each column, and highlighting all needed columns then right clicking to Combine Sum) and each time the formula allows me to complete it however there is no output in the column once I hit apply and OK. Here is an example:

Sum(
:RRT 1.059 + :RRT 1.074 + :RRT 1.076 + :RRT 1.079 + :RRT 1.081 + :RRT 1.082 + :RRT 1.084 + :RRT 1.124 + :RRT 1.125 + :RRT 1.129 + :RRT 1.130 +
:RRT 1.131 + :RRT 1.135 + :RRT 1.159 + :RRT 1.161 + :RRT 1.162 + :RRT 1.164 + :RRT 1.167 + :RRT 1.168 + :RRT 1.174 + :RRT 1.206 + :RRT 1.207 +
:RRT 1.208 + :RRT 1.210 + :RRT 1.214 + :RRT 1.215 + :RRT 1.236 + :RRT 1.256 + :RRT 1.278 + :RRT 1.302 + :RRT 1.304 + :RRT 1.306 + :RRT 1.307 +
:RRT 1.311 + :RRT 1.316 + :RRT 1.319 + :RRT 1.323 + :RRT 1.354 + :RRT 1.358 + :RRT 1.359 + :RRT 1.364 + :RRT 1.368 + :RRT 1.372 + :RRT 1.377 +
:RRT 1.493 + :RRT 1.564 + :RRT 1.566 + :RRT 1.570 + :RRT 1.602 + :RRT 1.604 + :RRT 1.615 + :RRT 1.617 + :RRT 1.624 + :RRT 1.634 + :RRT 1.636 +
:RRT 1.640
)

:RRT 1.059 + :RRT 1.074 + :RRT 1.076 + :RRT 1.079 + :RRT 1.081 + :RRT 1.082 + :RRT 1.084 + :RRT 1.124 + :RRT 1.125 + :RRT 1.129 + :RRT 1.130 +
:RRT 1.131 + :RRT 1.135 + :RRT 1.159 + :RRT 1.161 + :RRT 1.162 + :RRT 1.164 + :RRT 1.167 + :RRT 1.168 + :RRT 1.174 + :RRT 1.206 + :RRT 1.207 +
:RRT 1.208 + :RRT 1.210 + :RRT 1.214 + :RRT 1.215 + :RRT 1.236 + :RRT 1.256 + :RRT 1.278 + :RRT 1.302 + :RRT 1.304 + :RRT 1.306 + :RRT 1.307 +
:RRT 1.311 + :RRT 1.316 + :RRT 1.319 + :RRT 1.323 + :RRT 1.354 + :RRT 1.358 + :RRT 1.359 + :RRT 1.364 + :RRT 1.368 + :RRT 1.372 + :RRT 1.377 +
:RRT 1.493 + :RRT 1.564 + :RRT 1.566 + :RRT 1.570 + :RRT 1.602 + :RRT 1.604 + :RRT 1.615 + :RRT 1.617 + :RRT 1.624 + :RRT 1.634 + :RRT 1.636 +
:RRT 1.640

Re: No output result for summation of multiple columns

jthi — Thu, 17 Oct 2024 15:07:26 GMT

Is the formula evaluation suppressed?

Can you provide an example table which can be used to replicate the issue?

Re: No output result for summation of multiple columns

TAKAMX — Thu, 17 Oct 2024 17:40:09 GMT

Here are a few screenshots of a similar formula which also isn't giving any result. Data sample shows the table it is drawing the data from.

Re: No output result for summation of multiple columns

jthi — Thu, 17 Oct 2024 18:02:15 GMT

Sum() is able to handle missing values. Just change the + to , in the formula to separate different columns. Currently it is calculating "sum" twice. It should look something like this

Re: No output result for summation of multiple columns

TAKAMX — Thu, 17 Oct 2024 18:07:05 GMT

Thanks, Jarmo. Any way to do this for a much larger grouping of columns? For example, I have roughly 80 columns I need to sum into one column. Will do this manually if needed but was hoping there was a quicker way. Thanks.

-Travis

Re: No output result for summation of multiple columns

jthi — Thu, 17 Oct 2024 18:12:42 GMT

I would most likely do something like this to avoid scripting:

Select all columns of interest
Create quick formula using for example Combine/Min (everything is fine which fill wrap all columns inside single function, Min/Max came first to my mind)
Open the newly created formula and change Minimum to Sum in formula editor
Press OK, verify results and press Apply/OK
Change column name

Edit: I also created a wish list item in hopes that quick formula Sum would be changed to use Sum instead of Add