806541_en-US

liliconcom

No output result for summation of multiple columns

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

Automation and ScriptingBasic Data Analysis and ModelingRe: No output result for summation of multiple columns

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

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

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

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

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

1. Select all columns of interest
2. 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)
   1. 
3. Open the newly created formula and change Minimum to Sum in formula editor
   1. 
4. Press OK, verify results and press Apply/OK
5. 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

Make Sum quick formula use Sum() function instead of Add()