Report Conversion - Replacement for If(Like...)
We currently use the Insight expression If(Like. It was flagged as an error during the migration. BI has If and Like functions but there isn't an example using both together. Also, I do not see the Upper function. Below is the original Insight expression.
IF(((LIKE(UPPER([REQU|CUSTOM_1065]),"%ASSISTANT%")= TRUE) or (LIKE(UPPER([REQU|CUSTOM_1065]),"%SECRETARY%")= TRUE)),"Y" ,"N")
This expression scanned job titles looking for the text ASSISTANT or SECRETARY. If either was found in the title the result was sent to "Y" else "N". In addition, our titles can be mixedcase or uppercase which is why UPPER was used in the expression. How can I achieve the same result in BI?