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

    Combining two expressions

    Elizabeth Viso



      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!