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
Anaplan's next quarterly platform release webinar will be held October 28, 2026 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of…
We are pleased to announce the upcoming FCR 2610.1 GA release scheduled for the week of October 19th, 2026. Details can be found in the FCR 2610.1 Release Notes. Highlights Last Twelve Months (LTM) Calculation The system will automatically calculate Last Twelve Months (LTM) or Trailing Twelve Months (TTM) data using this…
