How do i get a total of multiple columns

Comments

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: https://help.grow.com/hc/en-us/articles/360013537353-How-to-Use-the-Calculated-Columns-Transform

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

    0
    Comment actions Permalink

Please sign in to leave a comment.