Iterate sum

[BautistaC888]

Hello,

I need to create the following iterative sum:

How could you achieve it with Alteryx?

Thank you.

[IraWatt · Accepted solution]

Hey @BautistaC888,

I think you want a multi row formula:

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