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
Best Answer
-
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
0
Answers
-
Thank @rob_marshall, I redesigned the solution and removed textlist after experiencing performance issue😅
0