Am wondering if there's a way to create a running sequence of numbers in Anaplan.
Am trying to create a sequence of numbers that run from 1 to N in columns such that 1 is in col 1, 2 in col 2 ... N in col N.
Reason am doing this is to see if there is a way to copy a certain cell value (say a number) from the left most column (col 1) to the right most column (col N). This can be done with say OFFSET or LAG but that will need to reference an offset value hence the running sequence.
This would be easy in Excel and am wondering how we do this in Anaplan. I have checked the formulas but do not see a formula that does this.