Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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