How can I incorporate null values as zero in a calculation?

[qlikmpate0]

I have a calculation  a- b but sometimes a or be may be null, how can I script this?

my code looks something like this at the moment:-

join(Temp table)

Load

*,
(A) - (B) as Diff;

[Anonymous]

Mina

Before your Load statement in your load script add a couple of lines similar to this :

Set NullValue = '0' ;

Nullasvalue [YourFieldName] ;

Load .......................

Best Regards,    Bill

[qlikmpate0]

thank you Bill, for your prompt response.

[qlikmpate0]

Thanks to all who replied, I ended on using the following:-

if(isnull(A), 0, (A)) - if(isnull(B), 0, (B)) as Diff;

Although the other suggestions are equally suitable.

Thanks again.