How to match value in List with code

Options
Leco1982
Leco1982 Member, ALL USERS Posts: 5 New Contributor
in Anaplan Community

Hi, All

Referring to the photo below

Suppose that there is a line item call YMD (value is 202006)

How to use this YMD to get the 'Test2' in List with matching the code (value is 20200620-2)  

無題.png

Tagged:

Comments

  • Leco1982
    Leco1982 Member, ALL USERS Posts: 5 New Contributor

    @jasonblinn 

    We can ignore '-2' , let's change the value from 20200602-2 to 202006

    in this case, how can i get the 'Test2' with some formula

    in other word, if i want to match the value(one or more) in List, which formula or method should i use ?

Categories