Previous Function that applies to lists

Options
robert_mahlum
robert_mahlum Member, ALL USERS Posts: 4 Master Anaplanner of the Year
in Anaplan Community
A previous function that applies to lists, not only to timescale.

Comments

  • hannahtwelve
    hannahtwelve Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor

    Hi,

    This was very helpful, thank you! I have a related question that I think is best to explain with an example:

     

    Let's say I have a list that is:

    1. Orange

    2. Pink

    3. Blue

    4. Purple

    5. Red

    I'd like to find a way to reference two behind in the list (i.e. if I was on Red, it would reference Blue (one behind Red is purple, two behind red in blue). I know how to do this with the use of the file you provided. However, now I am trying to figure out if I am on Orange, and I don't want it to be blank, I want it to go back to the end of the list to do the reference, so, one behind would be red, two behind would be purple. Do you know how to basically make this a circlular reference?

Categories