How do i get a total of multiple columns


1 comment

  • Avatar
    Scott Bowen

    Hi Rob! You can add (or subtract, divide, etc.) any columns together using the Calculated Columns transform. You can basically write out the math (first_column + second_column + third_column...) to create a new column with the result. 

    If you want a total of all the numbered columns in a report, you can also use the function "__rowSum" (with two underscores).

    See more examples with our Calculated Columns help article:

    If you need to get a total of an entire column, then you can use the "Sum, Count, Avg, Min, Max" transform.

    Comment actions Permalink

Please sign in to leave a comment.