- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: No output result for summation of multiple columns
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
Make Sum quick formula use Sum() function instead of Add()
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: 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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: No output result for summation of multiple columns
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
Make Sum quick formula use Sum() function instead of Add()