Can any one help me in this calculated column.
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