Alteryx Designer Desktop Discussions

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

Add up two columns in Formular Tool

MaxSchG
7 - Meteor

Dear all, 

 

I am getting kind of frustrated, thats why I am reaching out for your help. I would like to add up two columns ("aktiv" & "passiv")with the forumlar tool. The output should be a new column "Aktiv + Pasiv". I dont knwo why its not working. 

 

Please find the input, output and workflow attached. 

 

Thanks for your help in advance. 

 

Best Max

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula

Hi @MaxSchG ,

 

I think, only a small modification is needed. 

Replace the formula 

ToNumber([Passive Nachträge ]+[Aktive Nachträge])

with

ToNumber([Passive Nachträge ])+ToNumber([Aktive Nachträge])

 

Let me know if it works for you.

 

Best,

 

Roland

MaxSchG
7 - Meteor

How stupid of me.....

 

Thanks tho 🙂 

Labels