Hello, On the level 1 modelling exam I am getting stuck with a error when trying to convert a text line item to a list. Has anyone had similar error or know how to resolve? Many Thanks in advance!
@mrahma16
In order to convert Text Formatted Line item into List Formatted Line item we use FINDITEM function
Line item 1 - Formatted as Text
Line item 2 - FINDITEM(List 1, Line item 1)
Here List 1 is the name of the list from where you want to check if the text in Line item 1 matches any item in List 1
Hope that helps
Misbah
Check out the latest Anaplan feature updates and enhancements in our April 2026 official release notes. There you'll find information on: Polaris Trigonometry functions MOVINGSUM on general lists Line item limit Security and tenant administration CAPTCHA on basic authentication Anaplan XL (version 2604) Offline writeback…
If you missed our April 29, 2026 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…