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

Options

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

Best Answer

  • Tiffany.Rice
    Answer ✓
    Options

    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
    Options

     

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

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