Alteryx Designer Desktop Discussions

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

Formula tool Condition logic

arjundelara
8 - Asteroid

Hi All,

 

arjundelara_0-1612762326533.png

May I have a help tips on how this output in amount column get. There's a specific value in row 1 in column [Amount] then the amount value below will be a formula that is get in this condition "[Amount] row 1 + [Field2] row 2 - [Field1] row2" so on.

2 REPLIES 2
JulioMO
9 - Comet

Hi @arjundelara 

 

You may use the Multi-Row Formula Tool. 

 

Here is how you can do it: 

Example.JPG

 

I attach the workflow in case you need it. 

 

Regards

arjundelara
8 - Asteroid

It works perfect! Thank you.

Labels