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.
Yes. Thank you. Apparently, I did not look hard enough for this.
1 Like