Summing Values in 2 Columns

angelique_martin

Hi Alteryx Community,

I currently have a dataset where I am trying to sum the data in 2 columns into a new column. Below I have attached sample data set. In the screenshot, Column C is what I'm trying to get to. Any help will be greatly appreciated.

Thanks!

NicoleJohnson

Formula tool should do the trick! Add a new column ("C" in this example) and then use the following formula: [A] + [B]

Couple tips: Make sure your columns A & B have the right data type (something numeric), and then also make sure your new Formula "C" has a numeric data type as well (defaults to string type). 

Hope that helps! 

Cheers,

NJ