In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Top Solution Authors