Alternative to Formula

Question

IF
Contains("EM",[Description(Hrs. & Exp.)]) THEN 1
ELSEIF
Contains("IRSS",[Description(Hrs. & Exp.)]) THEN 1
ELSEIF
Contains("IRT",[Description(Hrs. & Exp.)]) THEN 1
ELSEIF
Contains("Retain",[Description(Hrs. & Exp.)]) THEN 1
ELSEIF
Contains("6.1",[Description(Hrs. & Exp.)]) THEN 1
ELSEIF
Contains("6.2",[Description(Hrs. & Exp.)]) THEN 1
ELSEIF
Contains("6.3",[Description(Hrs. & Exp.)]) THEN 1
ELSE 0
ENDIF

ShankerV · Accepted Answer

Hi @surajseshan

Please use the below.

IF
contains([Description(Hrs. & Exp.)],"EM") THEN 1
ELSEIF
contains([Description(Hrs. & Exp.)],"IRSS") THEN 1
and so on........

ShankerV · Accepted Answer

Hi @surajseshan

IF
contains([Description(Hrs. & Exp.)],"EM") THEN 1
ELSEIF
contains([Description(Hrs. & Exp.)],"IRSS") THEN 1
ELSEIF
Contains([Description(Hrs. & Exp.)],"IRT") THEN 1
ELSEIF
Contains([Description(Hrs. & Exp.)],"Retain") THEN 1
ELSEIF
Contains([Description(Hrs. & Exp.)],"6.1") THEN 1
ELSEIF
Contains([Description(Hrs. & Exp.)],"6.2") THEN 1
ELSEIF
Contains([Description(Hrs. & Exp.)],"6.3") THEN 1
ELSE 0
ENDIF

Hope it helps!!!!

ShankerV · Accepted Answer

Hi @surajseshan

I am assuming one more issue, if you use the same formula to write in String it will throw an error.

Use the below formula if your destination is string.

IF
contains([Description(Hrs. & Exp.)],"EM") THEN "1"
ELSEIF
contains([Description(Hrs. & Exp.)],"IRSS") THEN "1"
ELSEIF
Contains([Description(Hrs. & Exp.)],"IRT") THEN "1"
ELSEIF
Contains([Description(Hrs. & Exp.)],"Retain") THEN "1"
ELSEIF
Contains([Description(Hrs. & Exp.)],"6.1") THEN "1"
ELSEIF
Contains([Description(Hrs. & Exp.)],"6.2") THEN "1"
ELSEIF
Contains([Description(Hrs. & Exp.)],"6.3") THEN "1"
ELSE "0"
ENDIF