2 Replies Latest reply: May 12, 2017 10:06 AM by Elizabeth Viso RSS

    Combining two expressions

    Elizabeth Viso

      Hello,

       

      I have KPI's that show me reason items are failed with the expression:

       

      upper(left(trim(Reason),1)) & lower(mid(trim(Reason),2,len(Reason)))

       

      which works perfectly, but I also need to add if one of the reasons is inspection_tag to be replaced with Inspection Tag (no underscore), so I wrote this expression:

       

      If([Reason]='Inspection_tag',Replace([Reason],'Inspection_tag','Inspection Tag')))

       

      Each expression works fine alone but when I put them together I get an error. Can someone help me with this?

       

      Thank you!