How to subtract missing values

[#1]

Hi

In a staright table I am trying to subtract ' a missing value like

'-' - 800 its showing as zero instead of -800.

I want to subtract the missing values consedering them as zeros in a straight table.

Thanks

[ashfaq_haseeb]

Hi,

You need to replace null value with zero.

have a look at attached document.

Regards

ASHFAQ

[MK_QSL]

=IF(Len(Trim(Replace(YourFieldName,'-','')))=0 or ISNULL(YourFieldName),0)-800