How to fetch unique value using textlist function from child level to parent level

Hi,

I need help to get unique values using textlist

There is System module SYS01 at child level dimension with List A, I need fetch text value from line item X in SYS01 to Line item Y in SYS02 . The SYS02 module has dimension B which is parent of list A.

While using Textlist function Im getting error: 'SYS01'.Parent is not recognized as a hierarchy in the model.

The TEXTLIST function should take a hierarchy as argument.

The formula Im using is:

TEXTLIST('SYS01'.X , "," , 'SYS01'.Parent , UNIQUE)

The Parent line item is having list B format in SYS01 module

Accepted answers

rob_marshall

@swapnil_J

The function TextList() should be avoided at all costs as it is very performance and space heavy...Take a look at this post where David and I point out alternative solutions: https://community.anaplan.com/discussion/53085/lookup-sum-and-textlist-cheat-sheet

Rob

All comments

rob_marshall

@swapnil_J

Rob

swapnil_J

Thank @rob_marshall, I redesigned the solution and removed textlist after experiencing performance issue😅

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385