Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
Top Solution Authors