How to handle null fields in formula

[longlam]

Hello All,

I am using CRXI. I have done a left outer join to join two tables and one of the fields in the results will have a null value. I want to create a formula that does (FldA - FldB) but in the cases where FldB is null the formula does not produce an answer. I would like for the formula to treat the null value like a zero so that I can get the correct total. Any help? Thanks in advance.

 

[synapsevampire]

You can use File->Report Options->Convert null value to default.

Or you can code around it with:

if isnull(fldb)then
flda
else
flda-fldb

-k