How do I use the calculate a new column filter?

If you need to create a column using data from an existing column, you can use the Add Table Filter > Alter Column Structure > Calculate a New Column filter:

In order to cite a column you wish to work with, you can either use default 'Col #' or the custom column names you use via the Add Table Filter > Alter Column Structure > Name Column Headers filter:

Using default column names

Using named columns

This filter is flexible and supports all basic math operations, addition (+), subtraction (-), multiplication (*), and division (/), and supports order of operations by using parenthesis in your calculation:

If you have any questions or run into trouble getting set up please reach out to us at

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us