I have 3 fields and the first field is Amount the second field is Deposit and the third field is Balance.

Generally my calculation should be Balance = Amount - Deposit

If i insert the Amount, example $100 and the Balance automatically changed to $100.

I need the Balance remain empty unless i insert a number in the Deposit Field.

In my outstanding due report, if their is no Deposit, the Balance field should remain empty.

Any help.

Try =

If ( Deposit ; Amount - Deposit )

 

comment you are the best

Your solution worked fine.

Thanks a lot.