community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Rolling/Running Maximum

Meteoroid

Alteryx Newbie, here. Trying to add a column which will contain a rolling maximum (MAX_TAG) of the contents of another column (TAG), e.g.:

 

MAX_TAG.jpg

 

Presumably a multi-row formula is the place to start, but could do with some assistance..

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

If [row-1:Max_Tag] > [Tag] then [Row-1:Max_Tag] else [Tag] endif 

 

The above should do the trick within the multi-row formula tool.

 

Example attached.

 

Ben

 

 

Alteryx Certified Partner
Alteryx Certified Partner

@BenMoss is quite right.

 

You might also want to view this interactive lesson:  https://community.alteryx.com/t5/Interactive-Lessons/How-to-Fill-Your-Data/ta-p/82872

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Meteoroid

Thanks, both. =)

Labels