Super Contributor

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

Community Boss

RE: Convert list to text

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