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.
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