Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
20 - Arcturus
20 - Arcturus

@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