Can any one help me in this calculated column.

Hi ,

Can any one help me in this calculated column.  I have a department column which has values A,B,C,D,E,F,G and H.

 

I want to create a flag named "C- Departments Selected" .

 

Case when Department = C then yes ,When Department <> C then "No"  and  Department including C value as "All Departments".

 

Im using below logic

 

case  when [Department ]="C" then "Yes" when [Department]!="C" then "No" when [Managing Department Code] is not null then "ALL Departments" end

 

Im able to get only "Yes" and "No". I even need All Departments that includes "C" value also  I.e. A,B,C,D,E,F,G and H  in  "All Departments" text value.

 

Final Flag should be as below.

 

"" C -Departments Selected"  = Yes

                                                   No

                                                   All Departments

 

 

 

 

 

 

 

 

(8) Answers

Login