Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Add values in one column where there are values in another column

ericachae
6 - Meteoroid

Hi!

I'm trying to create workflow which will result below...

 

I would like to sum client amt where our amt is available..

 

<BEFORE>

Client AMTOur AMTAfter Our AMT
$380$360$240
$300 $290
$300$280$270
$100$100$90

 

<AFTER summarize tool>

sum of Client AMTsum of Our AMTsum of after Client AMTsum of after our AMT
$780$740$1,080$890

 

Thank you in advance...

3 REPLIES 3
ed_hayter
13 - Pulsar

I think i have what you want

binuacs
21 - Polaris

@ericachae one way of doing this

Screenshot 2023-06-28 164322.png

ericachae
6 - Meteoroid

all the answer came so quickly and perfectly worked.

 

Thank you all

Labels
Top Solution Authors