Alteryx Designer Desktop Discussions

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

Summing two columns

btarrow
5 - Atom

I have two fields in my workflow that both contain data as type double. 

 

I want to create a third column in which the first two columns are summed. 

 

I thought it would be as easy as a formula of column 1 name + column 2 name but it is not summing. 

 

I tried using ToNumber with the formula but then I lose my decimal places. 

 

Can anyone comment on what I am doing wrong?

 

Thanks, 

 

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @btarrow,

Can you give some example data. To add two columns together [column1]+[column2] should work if they are doubles.

btarrow
5 - Atom

Thank you for the quick response. I actually got it to work. I was pulling the data as non double earlier which was causing issues. 

 

Thank you, 

IraWatt
17 - Castor
17 - Castor

Great to hear @btarrow glad you got it sorted! 

Labels