Sum Over Multiple Columns?

Is there a transform for summing across multiple columns? I have a dataset with 12 months of data (in 12 columns) and would like a year total. I could use 11 calculate transforms to get the result, but that seems like a lot of work for something that seems basic. Essentially this would be a “Concat Cols” transform, but instead of treating the values in columns as text, the transform would add the values.

You can sum multiple columns by row using Stats.

Is that what you mean?

1 Like

Yes. Thank you. Apparently, I did not look hard enough for this.

1 Like