This content has been marked as final.
Show 4 replies
-
1. Re: Convert sys id list into name list?
Tom W Aug 24, 2016 6:33 PM (in response to Chrissy Scott)I would do it like this;
TRIM(mid(
if CONTAINS([Lineofbusiness],"A") then ",A" else "" end +
if CONTAINS([Lineofbusiness],"B") then ",B" else "" end +
,2,1000))
The MID function ensures you remove the leading trail off the first comma which is returned by the field.
-
2. Re: Convert sys id list into name list?
Chrissy Scott Aug 24, 2016 6:46 PM (in response to Tom W) -
3. Re: Convert sys id list into name list?
Tom W Aug 24, 2016 6:57 PM (in response to Chrissy Scott)Place your mouse over the squiggly line to see why you're getting an error. I can tell from looking at it, you've got another plus symbol at the end of line three but you're not "adding" it to anything after that symbol.
Make sure you have a comma in front of your global shareholder services in the second line too.
-
4. Re: Convert sys id list into name list?
Chrissy Scott Aug 27, 2016 1:09 PM (in response to Tom W)Thanks!