Comments
-
T
-
Thank you! That cleared the Syntax, but I'm not getting an actual value.
-
This is what I did, but I am getting a syntax error. Any thoughts on where I went wrong? SUM(CASE WHEN (Status='Clinic','Surgery') THEN 1 ELSE 0 END) / COUNT(Status)