Cognos Experts,
I need a little help with an expression. This Expression works, IF ([Phr NPI] ='1073861118') THEN ('PREFERRED") ELSE ('PREFERRED), but instead of using ='1073861118', I need it to evaluate against a list of Phr NPI's rather than equaling just one.
Basically I need something similar to this:
IF ([Phr NPI] InList('1699857490', '1073861118', '1881961662', '1770648933', '1467471490') THEN ('PREFERRED") ELSE ('NON-PREFERRED).
I know "InList" is not a COGNOS operator, but I used it to show what I'm trying to accompolish. I tried using the In_Range and Contains operators , but I get an error.
I need a little help with an expression. This Expression works, IF ([Phr NPI] ='1073861118') THEN ('PREFERRED") ELSE ('PREFERRED), but instead of using ='1073861118', I need it to evaluate against a list of Phr NPI's rather than equaling just one.
Basically I need something similar to this:
IF ([Phr NPI] InList('1699857490', '1073861118', '1881961662', '1770648933', '1467471490') THEN ('PREFERRED") ELSE ('NON-PREFERRED).
I know "InList" is not a COGNOS operator, but I used it to show what I'm trying to accompolish. I tried using the In_Range and Contains operators , but I get an error.