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
Please provide the actual error message.
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