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


                                                   All Departments









(8) Answers