Alteryx Designer Desktop Discussions

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

Iterate sum

BautistaC888
8 - Asteroid

Hello,

I need to create the following iterative sum:

BautistaC888_0-1653407254157.png

How could you achieve it with Alteryx?

Thank you.

1 REPLY 1
IraWatt
17 - Castor
17 - Castor

Hey @BautistaC888,

I think you want a multi row formula:

IraWatt_1-1653409884914.png

 

 

 

 

IF [RecordID]=1 THEN [Saldo] ELSE [Row-1:Saldo]+[AuxDebe]-[AuxHaber] ENDIF

 

 

This formula loops through each Saldo Row, if the record ID for that row is 1 then it takes the value of Saldo else it grabs the saldo above then adds Auxdebe and subtracts AucHaber from each row.

Multi-Row Formula Tool | Alteryx Help

Any questions/Issues make sure to ask :)

HTH,

Ira

Labels