I'm trying to sum a count of nulls. In my data set there is an entry of "null" but when I sum the equation below it shows 0.
If ISNULL([Cancellation Reason]) THEN 0 ELSE 1
END
The formula you have will return 0 if the entry is null, I think you want to flip the 0 and the 1 such that the equation is:
IF ISNULL([Cancellation Reason]) THEN 1 ELSE 0 END