Report variable returning the value for null instead of 0

[dodge20]

I have a smallint variable that is returning a value of -32768 (which I assume is the value) when it should return 0 or null. Is there anyway around this? Can you define a variable so that it returns 0 if it is null, (maybe add 32768 if is null)????

Thanks for your help.

Dodge20

 

[dodge20]

For future reference if anyone comes across this problem. I was unable to pass indicator variables to set the value to 0 if the variable is null, for reasons having to do with my code. I was able to get around this by changing the data type to decimal with no decimal places

variable mcount decimal(6,0)

decimal sets a null value to 0.

Dodge20