Convert list to text

Is there a function to change a list value to a text? I want to use the & operator with list values, but it only accepts text. When I try just using the list-formatted line items, I get the error below, so it seems that if I could convert the list selection into text then I'd be fine: The 'text1' argument for the '&' function should have datatype of TEXT not LIST:ILT Offerings:text1 & text2

2015-08-17_11-47-28_785.png

Accepted answers

ChrisMullen

Hi Amanda,

Have you tried using the NAME Function?
https://community.anaplan.com/anapedia/calculation-functions/name

This should allow you to switch the value from List to Text.

-Chris

All comments

ChrisMullen

Hi Amanda,

Have you tried using the NAME Function?
https://community.anaplan.com/anapedia/calculation-functions/name

This should allow you to switch the value from List to Text.

-Chris

Chmacpherson

Hello,

Question

I am trying to retrieve the display name from a numbered list and then convert it to text (i.e., keep my new line item as a Text Field).

Do you, or does anyone, know how to accomplish this?

Additional Context

My numbered list is comprised of employee IDs
The Display names are the actual employee names. This is what I need appearing in a module where I am creating a text field.

Many thanks,

Chad

rob_marshall

@Chmacpherson

Question, why are you wanting a text field when Text is less performant than a list formatted line item? Based on what you are stating, the Display Name is list formatted (which is the correct way of doing this) and I assume it is linked to an Employee Flat list of some kind. If that is the case, I would also assume the Employee Flat Display Name is text formatted. So, the formula would be:

employee Flat.Display Name[lookup: this list.Display Name] where "this list" is the list with a display name that is list formatted.

But again, try to stay away from Text.

Hope this helps,

Rob

Chmacpherson

Hey Rob,

Thank you for your speedy reply and apologies for my delay.

You raise a great point. I was heading down an unrealistic path, so this point helped me reframe what the issue was and approach it from a different angle.

Many thanks,

Chad

PranayG

Since the list is a numbered list, it returns a number, what should be done in that case?

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…