We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
Top Solution Authors