Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need help with a workflow to perform addition function

Taxguy03
9 - Comet

Hi Expert, 

 

We need your help with a workflow to perform the "addition" function between columns.

 

In this case, we would like to add the acct# "FCCS_Retained Earnings Prior" in the amount of ($1,315,398) from input#2 to input#1, acct# "FCCS_Retained Earnings Prior", column "E" SY2. 

 

The result should look like in the column "E" SY2  is = $1,945, 024 ($629,626+1,315,398). 

 

We don't need to do anything with column "C" Beginning or column "D" Ending. Only interested in column "E" SY2 for this workflow.         

 

I have attached sample files and workflow. 

 

Hope one of you can help.      

 

Thanks. 

7 REPLIES 7
Qiu
21 - Polaris
21 - Polaris

@Taxguy03 
Not an expert, but hope this will work for you.

1228-Taxguy03.PNG

Taxguy03
9 - Comet

Thanks for your quick reply, Qiu. Let me take a look and let you know if we have any questions.

 

By the way, you are an expert in my books:-) 

Taxguy03
9 - Comet

Hi Qiu, 

 

It looks like the attached .yxzp file is the original one and NOT the one you fixed.

 

Would you mind attaching the one you worked on (the screenshot above)? 

 

I would appreciate that, and sorry to bother you again. 

Qiu
21 - Polaris
21 - Polaris

@Taxguy03 
My apologies. 😅

 

Taxguy03
9 - Comet

No worries, got it this time. I will let know if we have any questions. Thanks again for your quick reply. 

Taxguy03
9 - Comet

Perfect, workflow. This is exactly what we need. Greatly appreciated. 

Qiu
21 - Polaris
21 - Polaris

@Taxguy03 
Glad to help and would appreciate you could mark my solution as accept 😁

Labels