Hi I want to Textlist function. I want to get Customers by Product List. But I don't know how to use it. ListLineitemProductCustomerConbinationTextListP1C1☑C1,C2 C2☑C1,C2 C3 P2C1☑C1,C3 C2 C3☑ Do you have any idea?

About textlist Formula

Hi I want to Textlist function.

I want to get Customers by Product List.

But I don't know how to use it.

List	Lineitem
Product	Customer	Conbination	TextList
P1	C1	☑	C1,C2
	C2	☑	C1,C2
	C3
P2	C1	☑	C1,C3
	C2
	C3	☑

Do you have any idea?

Accepted answers

All comments

Jitendra.Vishnolia

Hi @CommunityMember125605 ,

Just keep Product list only in applies to of Textlist line item. Then apply the Textlist formula at Customer list

TEXTLIST(Text to concatenate, Separator, List to reference [, Duplicate behavior])
pasting the screenshot for your reference

Hope this helps.

~Jitendra

CommunityMember125605

Hi, @Jitendra.Vishnolia !

I could solve it!

Thank you!

rob_marshall

@CommunityMember125605

Please don't use the function TextList as it has massive performance implications, there is a reason why it has it's own Planual rule (link). Instead, why create a module that is dimensionalized by Product and Customer and use Booleans? Also, please read through this entire post on ways to get around the use of TextList.

https://community.anaplan.com/t5/Anaplan-Platform/Lookup-Sum-and-Textlist-Cheat-Sheet/m-p/53085#M8205

Rob

CommunityMember125605

Hi, @rob_marshall.

I don't want to use text List, not boolean, Because I have to send a order to supplier.

Supplier needs Customer List per Product.

▲Supplier:S1
Order	Product	Amount	Customer
1	P1	100	C1,C2
2	P2	200	C2,C3
3	P3	300

rob_marshall

@CommunityMember125605

Then change the code of the transactional list to be product code_customer code with amount as the line item instead of your order number. With this, you can create two line items: Product and Customer that you can figure out by using the transactional code. Lastly, create a module dimensionalized my Product and Customer.

Now you have the dimensionalized which allows you to do all kinds of fun things.

I could be wrong, but i would doubt your source system stores your customers in one field as you have below.

Rob

rob_marshall

@CommunityMember125605

Or better yet, from your original post, you can create a module dimensionalized by Product and Customer, create a line item that does a sum on the amount. Now you can pivot it by Product and now see the customers as well as the amount without using textlist.

Rob

CommunityMember125605

Hi, @rob_marshall .

I know I can create module by product and customer and see amount of price.

But the point is text concatination.

Quick Links

Can you help?

Unanswered questions

Anaplan Excel Add-In SSO
Hello, I am working for an implementation partner where both my current client and my company use SSO to log-in. When accessing models via the browser, my workaround to ensure that I'm not redirected to my company's SSO is by using incognito / private browsing. However, I'm unable to do this when signing into the Excel…
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.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…