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

Expression Parssing Error

Started by cognos74, 22 Jul 2016 12:21:47 PM

Previous topic - Next topic

cognos74

Hi,

I am not sure what is wrong in my expression, I am getting parsing error before or near etc..

case
when ([Package Layer].[Employee].[GRADE] = 'AB' and [DEPT] = 40 then 'West' or [Package Layer].[Employee].[GRADE] = NULL and [HOSP] = 140 then 'CORP')
else
([Package Layer].[Employee].[GRADE])
end

couls you please help me

dougp

Please provide the actual error message.

HalfBloodPrince

case
when ([Package Layer].[Employee].[GRADE] = 'AB' and [DEPT] = 40 )
then ('West' )
when ( [Package Layer].[Employee].[GRADE] = NULL and [HOSP] = 140 ) then
('CORP')
else
([Package Layer].[Employee].[GRADE])
end