Retrieve List as Text used in Module

Highlighted
New Contributor

Retrieve List as Text used in Module

My model has a vintage or "Book Year" dimension which is being used as a list - we model that particular year's performance over time. I'm trying to create a module to result in a Boolean at the intersection of the Book Year and the Calendar year. I'm using a YEAR(ITEM(TIME))  = BookYear. However, I cannot seem to find a formula that is relative to the line item. Example: NAME requires that I select a specific year.

Since my model will add and remove years, I'd like this to be automated so it will update as Vintages are added.

Thoughts?

2020-07-01_16-41-49.png

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Retrieve List as Text used in Module

@rhightower 

 

See if this helps

Misbah_0-1593670555396.pngMisbah_1-1593670575479.png

 

Highlighted
Super Contributor

Re: Retrieve List as Text used in Module

Use name(item(list)) to get name of each list item