I am trying to run the following function in project
IIf([% Complete]=100,4,Switch([Text11]>80,3,[Text11]>50<80,2,[Text11]>1<49,1))
It runs successfully to return values 4, 3 and 2 but will not return value 1.
What do I need to do to make the the query run completely