Add up two columns in Formular Tool

Question

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

Output add up.xlsx

Input add up.xlsx

WF add up.yxmd

RolandSchubert · Accepted Answer

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