Unable to select item when display name contains newline

Highlighted
Occasional Contributor

Unable to select item when display name contains newline

This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed.

 

Issue

User will not be able to select numbered list item if display name contains newline.

 

Workaround

1. Remove newline from display name.

2. Programmatically remove the new line.

To achieve this, we will use a 2-cell helper module and the SUBSTITUTE function.

a. Create a module with 2 line items (we'll call them CR1 and CR2), no other dimensions. Set both line items to text.
b. Set the value of CR1 to 'a<newline>b'.
c. Set the formula of CR2 to MID('CR1', 2, 1). This will extract the <newline> from CR1.
d. Update property used for display name to use the SUBSTITUTE formula.
eg, SUBSTITUTE(<lineItem_or_property_with_newline>, CR2, " ")

 

If this workaround is not suitable in your use case, please contact Support at support@anaplan.com.

 

---

Internal Reference: CORECLI-2522

Message 1 of 1