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