Alteryx Designer Desktop Discussions

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

Multi-Row or Multi-Field Formula

w_gore
7 - Meteor

I am looking for some help with the preferred method to perform a simple subtraction on two amounts in the same column with the output as shown in screenshot 2 (see highlighted text and attached file).

 

w_gore_0-1664997701427.png

 

w_gore_1-1664997720959.png

 

 

2 REPLIES 2
binuacs
20 - Arcturus

@w_gore One way of doing this

binuacs_0-1665004296854.png

 

w_gore
7 - Meteor

Thanks for the reply.  That did the trick for my presented issue.  I had to make some changes because I did not mention my complete data set includes multiple co / account combinations.  This solution works for a unique co / account combo.

Labels