Experts, I have a wrong number of arguments in this SWitch statement:
PastDueOrPendingSWITCH: Switch([Due Date Per Docs]<Date() & Isnull([Completed]),"Past Due", IsNull([Completed] and [Due Date Per Docs]<Date(),"Pending", IsNotNull([Completed]),"Completed",1=1,"Other")
Not sure if "IsNotNull" is the issue. I also tried Nz([Completed]),"")="". I imagine it is a comma or a parenth but I dont see it.