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.

Add a column that checks row calculation

lipster26
7 - Meteor

Hello,

 

What is the best way to add a column that takes one column (B - Issue Cost additions) and subtract the sum of all other columns (C:U). In excel i'd have a formula B2-SUM(C2:U2)

 

lipster26_0-1648160621437.png

Thanks.

 

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@lipster26 

We can do the same as Excel of course if your columns are fixed all the time.
But if we want to be dynamic we can something like this.

0325-lipster26.PNG

Labels
Top Solution Authors