Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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