Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Summing Values in 2 Columns

angelique_martin
7 - Meteor

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!

angelique_martin_0-1633729095575.png

 

1 REPLY 1
NicoleJohnson
ACE Emeritus
ACE Emeritus

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

Labels