Rolling/Running Maximum

[Giles]

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.:

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

[BenMoss · Accepted solution]

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

[MarqueeCrew]

@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

[Giles]

Thanks, both. =)