14 Replies Latest reply: Apr 11, 2018 2:14 AM by Sasidhar Parupudi RSS

    if with multiple value of field

    Livio Sebastiano Colombo

      Hello to all,

      I have a problem.

      I have a field called SCENARIO and I would like to save the value of this in a variable, but according to the following condition:

       

      • If the SCENARIO field contains the following values "FC 1" and "FC 2" and "FC 3" then I want the variable to contain only the value "FC 3".
      • If the SCENARIO field contains the following values "FC 1" and "FC 2" then I want the variable to contain only the value "FC 2".
      • If the SCENARIO field only contains "FC 1" then I want the variable to contain only the value "FC 1".

       

      I tried with an if but without success.

       

       

      Thank you,

      Livio