In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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