If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

if condition in convert expression

Started by amu, 06 Jun 2012 09:18:43 AM

Previous topic - Next topic

amu

In the join query instead of setting the join relationship link,need to use "convert to expression" option

Is it possible to use a function as
"
IF ([Patient] = 'available')
    THEN ([Prescriber].[PRESCRIBER_KEY] = [Patient].[Patient_Key])

    ELSE ([Provider].[Provider_key] = [Patient].[Patient_Key])

"

I am getting error like "syntax error near "=" "