This content has been marked as final. Show 2 replies
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:
Each expression works fine alone but when I put them together I get an error. Can someone help me with this?