Alteryx Designer Desktop Discussions

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

How do I sum within the Formula Tool?

_JAA_
7 - Meteor

I don't see this addressed in previous questions. If I missed it, would you please direct me to that thread. 

 

I need to add Columns 1 & 2: 

Column 1Column 2
52

 

 

 

Thanks in advance-

5 REPLIES 5
Felipe_Ribeir0
16 - Nebula

Hi @_JAA_ 

 

You can use the formula tool to do it:

 

Felipe_Ribeir0_0-1672843981257.png

 

DanielG
12 - Quasar

@_JAA_ 

Assuming they are not string fields, it is just [Column 1]+[Column 2]

 

Otherwise you could do ToNumber([Column 1])+ToNumber([Column 2])

 

_JAA_
7 - Meteor

Thank you! For whatever reason, I was under the impression that would generate a concatenated field. 

DanielG
12 - Quasar

It will if they are strings

_JAA_
7 - Meteor

yes! i use 'To String' quite often. Thank you!

Labels