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

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels