Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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