Case statement in webi report throwing error

Hello Frnz,

I am trying to modify a webi report and adding a @prompt condition to it, but its throwing invalid relational operator error. Any suggestions please. Adding the query below i am using. Report is a custom SQL report.

case when ‘ALL’ in @prompt(‘BT:’,’A’,,Multi,Free,Not_Persistent,{‘ALL’,’B’,’D’},User:0) then 1
when ‘B’ in @prompt(‘BT:’,’A’,,Multi,Free,Not_Persistent,{‘ALL’,’B’,’D’},User:0) then
Case when trim(table.col1)) not in ‘U’,’V’,’W’,’X’,’Y’,’Z’ then 1
else 0
end

when ‘D’ in @prompt(‘BT:’,’A’,,Multi,Free,Not_Persistent,{‘ALL’,’B’,’D’},User:0) then
Case when trim(table.col1)) in ‘U’,’V’,’W’,’X’,’Y’,’Z’ then 1
else 0
end
else 0
end = 1

Error Message : 

TIA