I'm getting a zero count on using this code which I know is not correct, what is wrong?

```
SELECT CAST(SUM(CASE WHEN column != '' AND column IS NOT NULL THEN 1 ELSE 0 END)as int) as completecount
FROM clouddatabase.Table1

```

Thanks