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 🙂 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels