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..
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
@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
Thanks, both.
