Calculate view with SUM function

[eugz]

Hi All.
I have problem to fix a view in MS SQL. It looks like:

SELECT   Date_P, -SUM(is not null [Result]) AS Complete, 
		 -SUM(is null [Result]) AS [Not Complete]
FROM     dbo.Prob
GROUP BY Date_P

Message says: "Incorrect syntax near the keyword 'is'." How resolve that problem?
Thanks.

 

[ScottGem]

Try:

SELECT   Date_P, -SUM(Not IsNUll([Result])) AS Complete, 
		 -SUM(isnull([Result])) AS [Not Complete]
FROM     dbo.Prob
GROUP BY Date_P