We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Sum of 2 different columns and difference between the sums

gavinloi
8 - Asteroid

Hi all,

 

I am currently stuck with this alteryx workflow whereby i would need the sum of 2 different columns following that I would need the difference of the sums.

Using excel it looks and sounds easy but currently I am stuck. Would greatly appreciate the help. Example would be as below.

Thank you!

 

gavinloi_0-1645502060810.png

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@gavinloi 
Maybe we can do something like this.
Alteryx is processing the whole data stream, rather cells processing like Excel.

0222-gavinloi.PNG

gavinloi
8 - Asteroid

Thank you! @Qiu The solution worked wonders. :)

 

Qiu
21 - Polaris
21 - Polaris

@gavinloi 
Glad to help and thank you for the accept mark. 😁

Labels
Top Solution Authors