06-19-2018 05:17 PM - edited 06-20-2018 10:32 AM
I'm currently struggling to figure out how to create a calculated item that counts - total TCN and groups by claim type and MCO name. I don't know what the best way is to lay this out I am using the "IF ELSE" statement but keep getting a type mismatch message: "expected type at this location is Boolean, type of item being applied is Numeric" prompt when using the sub string and find string operators.
I am currently trying to use this format - see screenshot above ----any ideas folks?
06-26-2018 10:30 AM
FindChar returns a number for the first position of any of the desired chars to find. I think it returns 0 or -1 if none are found, so you need to make a modification to something like:
IF ( FindChar (inputs) > 0 )
and then it should work like you want.