Alteryx Designer Desktop Discussions

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

Cumulative sum for range of values

cgalea
5 - Atom

Hi Everyone,

 

I'd like to calculate the cumulative sum for a range of values. I've illustrated an example of the input and output below.

 

Alteryx_CumSum_Example.png

I've attached a sample file and would appreciate any help you can provide. 🙂

Charles

5 REPLIES 5
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @cgalea ,

 

Here is a workflow doing your cumulative sum based on active row and next row using Multi-Row Formula tool.

atcodedog05
22 - Nova
22 - Nova

Hi @cgalea 

 

Can you provide an explanation of the calculation? It's a bit unclear on how to arrive at the output.

Jean-Balteryx
16 - Nebula
16 - Nebula

I think it's active row value + next row value. That's what I determined from picture.

 

Not sure though.

cgalea
5 - Atom

Fantastic. It's just what I was after.

 

Thanks Jean-Balteryx!!

atcodedog05
22 - Nova
22 - Nova

Nicely done @Jean-Balteryx 🙂👍 This is more clear now.

Labels