In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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