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
Solved! Go to Solution.
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........
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!!!!
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