Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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