Help Me

[satyarao]

Hai !
I am working with Crystal Reports 8.5 ver.
i have designed a report from a query. in the report I wanted to have a formula field. I did it and it is working fine but... there is a problem with it .... if there is a value which is blank (null) then it is not returning any value... how to rectify this?

my query data will be as follows....

AccountName --- DebitAmount --- CreditAmount
----------------- ---------------- ------------------
RaviKumar-----------10,000.00------------2,000.00
Krishna----------------3,500.00-----------11,000.00
saradhi----------------5,000.00------------------------
Prasad----------------------------------------2,500.00
Raju--------------------4,000.00------------2,000.00

In crystal report.... i made formula field named.. BALANCE.

BALANCE =
if DebitAmount > = CreditAmount then
DebitAmount - CreditAmount
else
CreditAmount - DebitAmount


while using the above thing in CR.... i got the values of BALANCE column as

AccountName --- DebitAmount --- CreditAmount --- BALANCE
----------------- ---------------- ------------------ ---------------
RaviKumar----------10,000.00------------2,000.00----------8,000.00
Krishna---------------3,500.00-----------11,000.00----------7,500.00
saradhi---------------5,000.00----------------------------------------------
Prasad----------------------------------------2,500.00----------------------
Raju-------------------4,000.00-------------2,000.00----------2,000.00


[ Have u observed the above....? ]
for 3rd and 4th record there were no values are returned.....

Please solve my problem.....


Thanks in advance...