how to write if column (a list) contains x then 1 else 0

Jessv
Jessv
in Modeling

Hi there - 

am new to anaplan have only used excel extensively. I need to add a conditional colum (col 2)n based on another column (col1) which is a list type. That is if col1 contains "x1" or "x2" then 1 else 0. 

Thank you

Tagged:

Best Answer

  • Tiffany.Rice
    Tiffany.Rice
    Answer ✓

    Perhaps try using a selector module to define which list items you want to flag as a 1 and then in a separate module where the data lives do a LOOKUP to those list items you have flagged.  This allows you to dynamically control which line items should be selected rather than hard coding the formula.    Rough examples below to help illustrate. 

    TiffanyRice_0-1625106349093.png

     

    TiffanyRice_1-1625106400697.png

     

Answers

  • Jessv
    Jessv

     

    Hi im trying to update the success criteria actual column = if status is "Achieved" or "On Track" then 1 else 0?

  • Jessv
    Jessv
    status col is populated from a list
  • Jessv
    Jessv
    Thank you very much Tiffany that worked!!

Categories